Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Lookup mapping for multiple values

tiverson
8 - Asteroid

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

tiverson_0-1653655963434.png

 

Lookup table

tiverson_1-1653655991650.png

 

Desired output

tiverson_2-1653656123359.png

 

Any help would be appreciated

 

 

 

5 REPLIES 5
IraWatt
17 - Castor

Hey @tiverson,

I made a start looking at this problem:

IraWatt_0-1653657547152.png

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

tiverson
8 - Asteroid

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

 

IraWatt
17 - Castor

Hey @tiverson,

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

IraWatt_0-1653663370146.png

 

tiverson
8 - Asteroid

@IraWatt 

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?

tiverson_0-1653667155050.png

 

IraWatt
17 - Castor

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. 

Labels