Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, a have a table like this one:
I want the highlighted field named "measure" to be split in different columns with them respective values( secondo field highlighted: so I will have the column named Units with the value 9, 25, 40, 22. Like an inverse function of Cross Table. Can I do it in Qlik Sense?
Thank You!
Are you looking something like this?
tab1:
LOAD * INLINE [
ISO, Brand, measure, Date, Value
32, ABC, Units, 1/1/2018, 9
32, ABC, Units, 2/1/2018, 25
32, ABC, Units, 3/1/2018, 40
32, ABC, Units, 4/1/2018, 22
32, ABC, Units, 5/1/2018, 3
32, ABC, Units, 6/1/2018, 6
32, ABC, Units, 7/1/2018, 9
32, ABC, Units, 8/1/2018, 40
32, ABC, Units, 9/1/2018, 9
];
Gen:
Generic
LOAD ISO, Brand, Date, measure&'_'&Value,'X'
Resident tab1;
Drop Table tab1;
Using generic load can solve your issue as @Saravanan_Desingh wrote in the previous answer. I recommend developers to read this post, The Generic Load by @hic , when introduced to the Generic function.
Did you look into the above solution provided?