Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CSV data - Transforming data on load help

Hello,

I am looking for help to transform data which I load from a CSV from:

Project IDQuestionAnswer
1Tooling SolutionITRS
1Current Task Time (mins)10
1Current Task FrequencyDaily
1Started?Yes
2Tooling SolutionRBA
2Current Task Time20
2Current Task FrequencyWeekly
2Started?No

I was hoping to load in the data like so:

Project IDTooling SolutionCurrent Task time (mins)Current Task FrequencyStarted?
1ITRS10DailyYes
2RBA20WeeklyNo

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

1 Solution

Accepted Solutions
sunny_talwar

1 Reply
sunny_talwar

Look into Generic load: The Generic Load