CSV data - Transforming data on load help

[#1]

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

[sunny_talwar · Accepted solution]

Look into Generic load: The Generic Load