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
Solved! Go to 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
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!
User | Count |
---|---|
59 | |
26 | |
24 | |
22 | |
21 |