Data append

Question

Hello Everyone,

I am working on creating a model that appends data from two datasets. In the attached file, I have included two tabs: Data1 and Data2.

Data2 contains additional data that is not present in Data1. I need help in building a model that identifies the new data lines in Data2, and appends them to Data1.

Any assistance would be greatly appreciated!

Thanks,

Example.xlsx

davidskaife · Answer

Hi @Learner09

Can you share the workflow? If you have replicated the above, and joined correctly, what should be coming out of the right output is just the unjoined records from Data 2

Learner09 · Answer

@davidskaife thank you for the guidance, I created the model as per the approach, however, the right join providing all the 65 records, I need only those records that are not exist in Data 1.

davidskaife · Answer

Hi @Learner09

If i understand the requirement, you need to identify records on Data2 that doesn't exist in Data1, and join them together?

Try this, join the datasets together, then union the joined data to the data from the right output of the Join tool. You'll need to ensure you untick the duplicated columns in the Join tool.

An alternative approach would be to Union the data together, then remove duplicates using a Unique tool