Trying to add results for multiple columns using muliple joins.

[alexloudon]

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

[Yoshiro_Fujimori · Accepted solution]

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

[flying008 · Accepted solution]

Hi, @alexloudon 

[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!