Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Lookup question

Manjari
8 - Asteroid

Hi All,

Requesting help on the below look up question. 

I tried using text to columns and then mapping them separately, but I do not know how many columns the text to column tools to split. in the below example the first row is 3 next is 5 next one can be 10. Is there a robust way to do this. 

I have a Data set 

Data set
A;B;C
F;G;H;J;K
L;M;N
M;J
E;
D;

 

I have a lookup table 

Lookup ValueLook up array
AApple
BBasket
CChocolate
DDenmark
EElephant
FFriday
GGoat
HHitler
IIndia
JJerry
KKite
LLemon
MMango
NName

 

I want my output to be like:

Output
Apple;Basket;Chocolate
Friday;Goat;Hitler;Jerry;Kite
Lemon;Mango;Name
Mango;Jerry
Elephant;
Denmark;
2 REPLIES 2
PeterA1
Alteryx
Alteryx

Hey @Manjari ,

 

Parsing to rows usually does the trick with a record id added! 

 

Please see attached and let me know if this answers your question

Manjari
8 - Asteroid

Thank you @PE_dup_233 this worked like a charm 🙂

Labels