Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

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

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.

xxx.PNG

1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

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

Try this:

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

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
3 Replies
rachel_delany
Contributor

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

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
Valued Contributor III

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

Try this:

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

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
stuhico09
Contributor

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

Thanks Thiago. it works as expected.

Community Browser