Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
karan_kn
Creator II
Creator II

Parsing Field Values in Load Statement

Parsing Field Values in Load Statement, could you please help us to extract specific values based on underscore 

Pick Node=1_4_5_6_8 from Fieldname

FieldnameNewField
100254_AM96_Text_Greece_Euro_2589_AMT_Y100254_Greece_Euro_2589_Y
100254_AM23_INT_India_Asia_578_AMT_H100254_India_Asia_578_H
100254_AM56_Text_Japan_Asia_256987_AMT_Y100254_Japan_Asia_256987_Y
1 Solution

Accepted Solutions
brunobertels
Master
Master

Hi 

try this 

subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',1)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',4)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',5)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',6)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',8)

replace '100254_AM96_Text_Greece_Euro_2589_AMT_Y' by your fieldname 

View solution in original post

1 Reply
brunobertels
Master
Master

Hi 

try this 

subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',1)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',4)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',5)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',6)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',8)

replace '100254_AM96_Text_Greece_Euro_2589_AMT_Y' by your fieldname