Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Pivot (double vlookup) to get data

Gexo
5 - Atom

I have two inputs:

 

Input 1

OrderCodeTypenumberdata
2132342AUSABC11 
12412342USADEF23 
12323432USADEF22 
213231MEXABC21 
45345CANDEF32 
345233CANABC22 
12342534USADEF12 

 

Input 2

CodeABC 11/12ABC 21/22DEF 11/12DEF 22/23DEF 31/32
AUS55714
USA34565
CAN82226
MEX19257

 

I'm trying to find a way to find the data from Input 2 using the Code, Type and number from Input 1 in order to get:

 

OrderCodeTypenumberdata
2132342AUSABC115
12412342USADEF236
12323432USADEF226
213231MEXABC219
45345CANDEF326
345233CANABC222
12342534USADEF125

 

Any help is highly appreciated!

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Use a transpose tool to get column names and values from table 2 into a field.

You can then use regex to break into Type and Number

I am guessing 11/12 means 11 or 12, so I used a text to columns to break to rows

2016-08-17_11-53-29.jpg

Sample attached.

Gexo
5 - Atom

Thats exactly what I was trying to do.

 

Thank you very much for your help!

Labels
Top Solution Authors