create a new table in load script

[Anonymous]

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]

Hi, try this may be it works

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

[sunny_talwar]

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