We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Trying to add results for multiple columns using muliple joins.

alexloudon
6 - Meteoroid

Apologies if my question is a bit confusing, I've added an example workflow to illustrate my point. I'm working with a complex data set where I've 10 columns, each with a specific time in it. I've a separate table which has a result attributed to each time. I'm trying to find out if there is a way to perform the lookup for each time column and add the corresponding result. So in the end I will have 10 times and 10 results for each row of data. Currently I've just been performing 10 joins and adding 1 extra field at a time, but it seems like there should be a better way of doing things. Any help with the above would be hugely helpful. Thanks so much

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @alexloudon ,

 

If you do not stick to one row, you can transpose the columns to rows under a single column.

And you will be able to JOIN with the single column.

I hope this helps.

 

Workflow

MultipleJoins_1.png

Output

MultipleJoins_2.png

flying008
15 - Aurora

Hi, @alexloudon 

 

录制_2023_08_01_14_30_40_783.gif

alexloudon
6 - Meteoroid

Thank you very much, I completely forgor about transposing. This worked beautifully, I then had to cross tab the results backwards afterwards whic was also fine!

Labels
Top Solution Authors