Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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_

Try this:

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

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

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

View solution in original post

3 Replies
rachel_delany
Creator II
Creator II

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_

Try this:

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

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

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
Anonymous
Not applicable
Author

Thanks Thiago. it works as expected.