SOLVED
Iterative or Batch Macro
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Assaf_m
11 - Bolide
‎08-25-2022
01:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
2 REPLIES 2
DataNath
17 - Castor
‎08-25-2022
02:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
‎08-25-2022
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.