topic create a new table in load script in QlikView

create a new table in load script

Anonymous — Sat, 16 Nov 2024 05:12:19 GMT

I have data loaded in with fields,

id, workflow, score, Reference

Each ID is unique
There are 3 possible workflows (wf1, wf2, wf3)
Each Reference may have 1, 2 or 3 of the workflows present and represents a single person giving scores at each touchpoint

How can I create a new table in the load that gives me;

Reference, wf1_score, wf2_score, wf3_score

I have tried

LOAD
Reference,

if(workflow='wf1', score) as wf1_score etc

but this doesnt seem to be working. Is there a better way?

sasis551 — Mon, 19 Nov 2018 10:32:46 GMT

Hi, try this may be it works

if(workflow='wf1', workflow) & '_' & score as wf1_score etc

sunny_talwar — Mon, 19 Nov 2018 12:19:00 GMT

Would you be able to share some data to explain as to what you have and what you want to get from it?