nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to save a joined table into the right folder

unknown

Hello everyone,

I am working on a project that needs to update new data into the original data file. I am using join table function now. The issue is that I can't save the joined data table into the right place. What I am trying to do is 1. pull out last 14 days data from the database, 2. open the original data file 3. join these two table 4. replace the original table by joined table. The issue is that last 14 days data table is saved but not the joined table.

I will appreciate a lot if you can help.

Accepted answers

All comments

cwillden

When you do a join, there is an option to "Update main table with data from second table". Using that option, you could just save the original table after you've updated it. To invoke this option, you just need to add "Update main table with data from second table(1)," somewhere in this code snippet:

Drop multiples( 1, 1 ),
Include Nonmatches( 1, 1 ),
Preserve main table order( 1 ),
Output Table( ::dt_activeRI:Lineage[rowNum] || "_RI_" || Char( ::dt_activeRI:InvestigationId[rowNum] ) || "_FieldArray.jmp" )

unknown

Thank you for your answer, I did update but new data table is still created.

unknown

Hello everyone,

My isuee is still exist. I need help either on join two tables and update data on the origanal table or save the new table correctly.

I will appreciate your help a lot.

Thanks,

Wen

Jeff_Perkinson

Looking at your code it looks like the line:

Close( dtjoined, save( savepathFieldArray ) );

should be saving the joined data table.

When you say that the "last 14 days data table is saved," do you mean that the last 14 days of data are saved into the file you specify with savepathFieldArray?

Can you provide an example of the two files (main and 14 days) that will reproduce the problem? If not the actual data can you use some dummy data that exhibits the same behavior?

Also, Tables->Join always creates a new data table, even when the "Update main table with data from second table" option is used. Tables->Update will update a data table in place.

unknown

Hello Jeff,

Thank you so much for your reply.

Yes, the last 14 days of data are saved into the file that I specified with savepathFieldArray. But I want to save the joined data table with all of the data. I don't want the "last 14 days data table" being saved.

Thanks,

Winnie