Comparing data one field at a time

Hi Everyone,

I've been asking a lot of questions lately but I feel that its better to ask rather than struggle. Currently I' comparing two different data sets one field at a time and its becoming very tedious.

In essence I'm basically recreating VLookups a colleague had done in Excel using the Join but since I'm doing it one field at a time I need to use a new Join every time as I cannot compare more than one filed at once. Is there something I can do to be more efficient doing this in Alteryx.

This might be stupid question but is there a way possibly enhance this and be more efficient. Cheers to you all in advance

Workflow

Help

Accepted answers

Ben_H

Hi @Deano478,

Depending on how exactly your data is structured and what checks you are trying to do you could always just transpose your inputs first, then join. that way you can potentially compare everything in a single operation.

As has been previously suggested if you can provide a sample dataset we can give you more specific help.

Regards,

Ben

All comments

DenisZ

I guess you could use a macro to do it. If you could provide an example dataset then it would be easier to help.

Sebastiaandb

Hi @Deano478 ,

You might be interested in the crewmacro's.

Especially the expect equal tool like discussed here:

Comparing Two Data Sets - Alteryx Community

You can download them here:

Chaos Reigns Within: Macros

Greetings,

Seb

Deano478

Hey @Sebastiaandb I appreciate the guidance on this matter because the manual way is getting very tedious. I'll read into the Crew Macro and see what its capabilities are Many Thanks

Sebastiaandb

Awesome @Deano478 , let me know if it works for you :-)! Greetings, Seb

Ben_H

Hi @Deano478,

As has been previously suggested if you can provide a sample dataset we can give you more specific help.

Regards,

Ben

Deano478

@Ben_H thank you this method was very helpful I was able to get my desired result and even put in a Cross tab tool to get my data back to a horizontal orientation when I had the workings done.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703