How to load data in script to get new column. (Qlik Sense)

[Anonymous]

Hi,

How can i load my data to get below result?

Initial field: "Id No"

I want to separate it into 2 field. "Id No" and "Version". Please help. Thanks.

[rachel_delany]

Hi,

You should be able to do the following:

Subfield("Id No",'_',2) AS [Id No],

Right("Id No",1) AS Version

Hope that helps.

[Thiago_Justen_ · Accepted solution]

Try this:

Subfield("Id No",'_',2) AS [Id No],

Subfield("Id No",'_',3) AS Version

[Anonymous]

Thanks Thiago. it works as expected.