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: 
Not applicable

¿How create a field with modifications?

Hi there,

I have a column (USERNAME) in Excel file that contains a information. I need to extract some information:

 

Name
FME_78701234
FME_71311233
FME_11281242
FME_71241244
FME_11241241
FME_92124124
FME_71241241
FME_71241242
FME_11231233
FME_71231233
FME_71231231

I need create the next field

Name 2
78701234
71311233
11281242
71241244
11241241
92124124
71241241
71241242
11231233
71231233
71231231

I can should be filter by Name 2.

I need solve this issue in QlikSense without any change in Excel File.

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Juan,

One way to achieve this is by using 'mid' function in the load script. This way you can split the value and capture it in another column. Pls check the attached screen that has the load script syntax and the 2 list boxes showing the value.

SplitColumn.PNG

View solution in original post

4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

You're asking this in a QlikView forum. Maybe you can move this thread to the proper area? Otherwise you may get irrelevant (or no) answers...

Best,

Peter

Anonymous
Not applicable
Author

Hi Juan,

One way to achieve this is by using 'mid' function in the load script. This way you can split the value and capture it in another column. Pls check the attached screen that has the load script syntax and the 2 list boxes showing the value.

SplitColumn.PNG

swuehl
MVP
MVP

You can also use Subfield() with a delimiter '_' in your LOAD script:

LOAD

     USERNAME,

     Subfield(USERNAME,'_',2) as NAME2,

     ...

Gysbert_Wassenaar

Or one of these:

  • Replace(USERNAME,'FME_','') as NAME2
  • keepchar(USERNAME, '0123456789') as NAME2
  • mid(USERNAME, Index(USERNAME, '_')+1) as NAME2


talk is cheap, supply exceeds demand