Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Split the field

HI all,

 

I have data like this below 

Pdt mismact errod
1 M01M02M03MO4

 

I want to get the data as below while loading

Required O/P

Pdt mismact errod
1 M01
1 M02
1 M03
1 M04

 

Any help much thanks to you

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

Simplest way 

LOAD Pdt, SubField(Trim(Replace([mismact errod], 'M', ' M')), ' ') as [mismact errod]Inline [
Pdt, mismact errod
1, M01M02M03M04
];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

Simplest way 

LOAD Pdt, SubField(Trim(Replace([mismact errod], 'M', ' M')), ' ') as [mismact errod]Inline [
Pdt, mismact errod
1, M01M02M03M04
];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful