I have data that has accounts that may have a TP assigned to them
The data will only have one TP assigned to it, but the lookup table has multiple combinations that may work.
I want to return the Lookup value to my data in a new column
Data
Lookup table
Desired output
Any help would be appreciated
Solved! Go to Solution.
Hey @tiverson,
I made a start looking at this problem:
I'm not 100% understanding the logic but I think transposing the mapping is definitely a first step.
Let me know what you think is missing.
Thanks,
Ira
@IraWatt, I want the data to return the lookup value that fits the account & TP combination.
Examples:
If Account is 1234 and TP is "A", then return lookup value 1234 ABC
If Account is 1234 and TP is "B", then return 1234 ABC
If Account is 1236 and TP is "J", then return 1236 <F>.
If Account is 2536 and TP is "J", then return 2536 JKL
If Account is 379 and TP is empty, then return 379
I hope this helps.
Hey @tiverson,
Looking at the workflow ive attached it has joined on all the values you gave there. Is it working as expected?
Your solution looks like it will work, however when I tried to download it I received the following message and the workflow did not open.
How to I work around this?
HHmmm @tiverson think if you just click okay it should work. Sometimes it closes but you can open the workflow in the unzipped file. If that doesn't work let me know, there are a few work arounds.