Iterative or Batch Macro

Assaf_m

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

RecordID	Code 1	Code 2	Code 3	Code 4	Code 5	Code 6	Code 7
1	A	W	T	R	X	F	V
2	R	E	W	E	R	T	Y
3	Q	E	D	R	S	H	D

Table2 around 23 Million records

RecordID	Excl. 1	Excl. 2
1	D	G
2	C	F
3	R	Y
4	Q	A
5	A	B

Output

RecordID	Code 1	Code 2	Code 3	Code 4	Code 5	Code 6	Code 7	Output	Table2 RecordIDs
1	A	W	T	R	X	F	V	No	N/A
2	R	E	W	P	O	T	Y	Yes	3
3	Q	E	D	A	S	H	G	Yes	1,4

DataNath

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:

Letter combo batch macro.yxzp