How can take only one value from multiple values with in one cell

[rkpatelqlikview]

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.

[jaumecf23 · Accepted solution]

Try this:

Table:

LOAD Store,

     codes,

     trim(SubField(codes,',',1)) as Final

FROM

[Final.xlsx]

(ooxml, embedded labels, table is Sheet1);

[rkpatelqlikview]

Thanks for your great help Jaume,