Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please let me know whether we can convert row fields to column header format and load data in qlik. Please check attached.
Regards,
Pratik Advani
Give more details on how you want it?
You XL sheet is not just rows...
The rows are messed up
attach an image and explain please..
Please check below screenshot which contains both original data and expected output.
Original data
Expected output:
Ok,
whats the full data?
You just want these as columns?
if(A='TASKS COMPLETED',' ') as [TASKS COMPLETED],
if(A='TASKS IN PROGRESS',' ') as [TASKS IN PROGRESS],
if(A='TASKS TO BEGIN NEXT WEEK',' ') as [TASKS TO BEGIN NEXT WEEK],
if(A='URGENT ISSUES',' ') as [URGENT ISSUES],
if(A='SELF ASSESSMENT & COMMENTS',' ') as [SELF ASSESSMENT & COMMENTS]
From.....
I couldn't make a single field in Cross Table and it seem here we are removing values from dimension and using it as a dimension.
to be honest what goes inside those columns is more important... and how you want to link...
Just creating columns can be done in quite a few ways but that's not the answer for this.