Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Key-Value Pairs for every cell

Ibryam_Ibryam
5 - Atom

Hi everyone,

 

I am trying to match key value pairs based on the attached dataset. For every cell we are trying to match a key value from list first from the right and then from the underneath of that cell.

 

Lets say for example we take cell A9: see file sss

 

For the final table essentially, we need to have 2 rows for every cell.

 

Many thanks in advance

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Ibryam_Ibryam 
I can not connect the image sample with your sample dataset.
Can you elaborate a bit more?

Raj
15 - Aurora

 This information seems incomplete please attach the expected out and some more explanation.

Labels