Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Iterative or Batch Macro

Assaf_m
11 - Bolide

Hi Community,

 

I need help in building a macro for a huge data set that goes through table2 and check if any combination is there in table1, in other words, we need to see in table1 if any 2 codes that are not supposed to be in the same row using table2 as a reference and regardless of code order in table2

 

Table1

RecordIDCode 1Code 2Code 3Code 4Code 5Code 6Code 7
1AWTRXFV
2REWERTY
3QEDRSHD

 

Table2 around 23 Million records

RecordIDExcl. 1Excl. 2
1DG
2CF
3RY
4QA
5AB

 

Output

RecordIDCode 1Code 2Code 3Code 4Code 5Code 6Code 7OutputTable2 RecordIDs
1AWTRXFVNoN/A
2REWPOTYYes3
3QEDASHGYes1,4

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Had a quick go at putting something together @Assaf_m - how does this look? You should just be able to replace the far left Text Input tool with your main data set:

 

DataNath_0-1661418408131.png

Assaf_m
11 - Bolide

Thank you @DataNath

 

I had to do a few adjustments to change both inputs. but your workflow was really helpful for me :)

 

Will let you know if I face any issue

 

Much appreciated.

Labels
Top Solution Authors