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...

Datasets

Best Practices

Help

Accepted answers

alexnajm

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!

All comments

alexnajm

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703