Comparing two different datasets

[HarshDB2018]

I've two datasets with two columns. Case ID and Amount. I would like to compare these two datasets in Alteryx and for the one's where there is a difference in amounts, it will be added to an existing workflow and for the one's where there is no difference in amounts for the respective Case ID's, that'll be added to another existing workflow. 

Any help would be appreciated. 

Thanks in advance...

[alexnajm · Accepted solution]

Sounds like a Join on the two datasets, a Filter to where the amounts are different across Case IDs, and the split going to two different outputs for two different workflows!

[HarshDB2018]

Hi,

Thanks for the reply Alex. Yes, I've joined the two datasets but unable to compare the amounts for both and not sure as to which tools to be used further for the comparison to get the desired output.

[alexnajm]

Why are you not able to compare? A join on Case ID should put the amounts side by side for comparison by either a Formula / Filter as suggested

[HarshDB2018]

Thanks Alex. I'll try as suggested.