Hi everyone.
I have a following task.
Given a table, which is like:
Id | 09.01.2017 | under val/upper val | 10.01.2017 | under val/upper val |
#1 | 333 | 14 | 250 | 9 |
Null | Null | 19 | Null | 4 |
#2 | 589 | 11 | 57 | 12 |
Null | Null | 55 | Null | 23 |
Totally, there are many columns with dates headers (~250 pc)
I need to make this table plain and get smt like this:
ID | Date | Under val | Upper val |
1 | 09.01.2017 | 14 | 19 |
1 | 10.01.2017 | 9 | 4 |
1 | ... | ... | ... |
2 | 09.01.2017 | 11 | 55 |
2 | 10.01.2017 | 12 | 23 |
2 | ... | ... | ... |
... | ... | ... | ... |
Please help!
Solved! Go to Solution.
Hey @daniilgurin ,
I'm guessing there may be a simpler way than the way I came up with but it should be totally dynamic for however many columns, ID's or dates that you have! Check out my attached workflow - I've put in a bunch of documentation to help explain but let me know if you have any questions. And please mark as a solution if this worked so others can find it!
-Chris
Hi @daniilgurin
I had a crack at this. My solution feels a bit overcooked, but it does work (assuming you only want the under/over values)
Let me know if that helps
Ollie
Thought I was overcomplicating it. @ChrisHe has the answer you want
Hi @daniilgurin ,
Great challenge you have there.
Since I was already developing a solution, I went through and finalize it.
It is pretty fun to see all these different solutions for the same problem @OllieClarke , @ChrisHe .
Best,
Fernando V.
Guys, thanks for your help!