Lookup mapping for multiple values

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

NCE TP map.xlsx

Transformation

Accepted answers

Looking at the workflow ive attached it has joined on all the values you gave there. Is it working as expected?

example2705.yxzp

All comments

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

Example 2705.yxmd

@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.

Looking at the workflow ive attached it has joined on all the values you gave there. Is it working as expected?

example2705.yxzp

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.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703