Hi All, I'm trying to do a relatively simple lookup to fill in a table using another master table with all of the possible combinations.
I have a master table with data that looks like this (~1,000,000 records, 3 fields)
Item 1 | Item 2 | Result |
0001 | 0001 | 5 |
0001 | 0002 | 7 |
0001 | 0003 | 3 |
etc. | etc. | etc. |
And I'm trying to fill in a table that looks like this (30x200). I need it to lookup each one and fill in the cell with the result (then export to a csv, Excel, etc.), but can't get it to work.
0001 | 0002 | 0003 | 0004 | 0005 | 0006 | |
0001 | ||||||
0002 | ||||||
0003 |
Hi @jwallen23
I think this is what you want, and this should work as a logic with no more steps if you have no duplicate cells:
I'm transposing the master table so I can join it onto the other table, putting the result in the correct column, and then cross tabbing it back.