Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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