Discussion Board for collaboration related to QlikView App Development.
I have a data set from Excel which column 2 is the comma delimiter data of profit center.
Column 1 , column 2
HK , V1,V2,V3,V4
How do I normalize the dataset so it read
US P1 etc.
Using crosstable ? Tried the wizard but I can't get it .
May be like this?
Asumming the excel is:
With a script like:
LOAD A as Column1,
SUBFIELD( B,',',1) as Column2,
SUBFIELD( B,',',2) as Column3,
SUBFIELD( B,',',3) as Column4,
SUBFIELD( B,',',4) as Column5
(ooxml, no labels, table is Hoja1);
you will get a table like:
Hope that helps.
i think crosstable is not required for 2 columns excel like
the script is
LOAD Col1, SubField(Col2, ',')
(ooxml, embedded labels, table is Sheet1);
You dont need crosstable, you need to use SUBFIELD ()
SUBFIELD (Column2,',') AS NewColumn2
great . working well with the subfield . Thanks everyone
If you got answer, can you please mark Answered Question or Helpful Question to close this thread and other user can use also use it?