Compare and Merge data

[kskarthikeyanks]

Hi all,

I need to compare two sets of data.

Then I need to overwrite the data 1 (old data) with the data 2 (new data) for the common rows. 

I need to merge the unique rows and the common rows with the latest data

Please help me in this regard, as I am new to AL

[ChrisTX]

Can you post your sample data in a table or an Excel attachment (not an image)?

[OTrieger]

@kskarthikeyanks 
To be able to compare the data you will need to have both set of data. So after competing with the comparison just replace the old data with the new data. You actually not need to "replace" just remove the old data and write out the new data.

[kskarthikeyanks]

Here you go. Appreciate your help

[kskarthikeyanks]

Thanks for sharing the logic. Please could you share the workflow. that would be helpful

[OTrieger]

@kskarthikeyanks 
You should be able to join to source of data into one WF. I do not see what is the reason to create a WF. Figure out how to merge the 2 datasets, as this will be a basic thing that you will need to do with Alteryx.

There are interactive lessons, weekly challenges and the community to learn from. 

[kskarthikeyanks]

I have merged the 2 datasets into file. 

But I am struggling to overwrite the old data with the new one for the rows that are matching. 

Then I need to combine the unique data from both datasets (old and new) with the common rows with the overwritten data