Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik,
Anyone please help on this.
There is a multiple values in one cell, Here i need to consider only first one. Please find the excel like Final Column.
Try this:
Table:
LOAD Store,
codes,
trim(SubField(codes,',',1)) as Final
FROM
[Final.xlsx]
(ooxml, embedded labels, table is Sheet1);
Try this:
Table:
LOAD Store,
codes,
trim(SubField(codes,',',1)) as Final
FROM
[Final.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thanks for your great help Jaume,