Trying to add results for multiple columns using muliple joins.

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

Example Workflow.yxmd

Workflow

Help

Accepted answers

Yoshiro_Fujimori

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

Output

Example Workflow.yxmd

flying008

Hi, @alexloudon

录制_2023_08_01_14_30_40_783.gif

All comments

Yoshiro_Fujimori

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

Output

Example Workflow.yxmd

flying008

Hi, @alexloudon

录制_2023_08_01_14_30_40_783.gif

alexloudon

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703