Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking for help to transform data which I load from a CSV from:
Project ID | Question | Answer |
---|---|---|
1 | Tooling Solution | ITRS |
1 | Current Task Time (mins) | 10 |
1 | Current Task Frequency | Daily |
1 | Started? | Yes |
2 | Tooling Solution | RBA |
2 | Current Task Time | 20 |
2 | Current Task Frequency | Weekly |
2 | Started? | No |
I was hoping to load in the data like so:
Project ID | Tooling Solution | Current Task time (mins) | Current Task Frequency | Started? |
---|---|---|---|---|
1 | ITRS | 10 | Daily | Yes |
2 | RBA | 20 | Weekly | No |
The reason I want to do this is because I have another table with the project ID and other details on the project (1 row per project ID). I want to get all of the question and answers on to one row too - I was trying this with an expression:
=if([Question]='Tooling Decision:',[Answer])
and then in next field "=if([Question]='Current Task Time (mins)',[Answer])"
for example... this was then giving me 2 rows per project ID (So with above data it would have 4 rows per project - in reality i have 8 questions)
Hope this makes sense!!
Thanks,
Lizi
Look into Generic load: The Generic Load
Look into Generic load: The Generic Load