Compare and Merge data

Question

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

Alteryx Help - JAN 2025.JPG

kskarthikeyanks · Answer

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

OTrieger · Answer

@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 · Answer

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