Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist
‎2019-12-06 05:45 AM

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)
Labels
367 Views
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2019-12-06 05:51 AM

Simplest way 

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

359 Views
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2019-12-06 05:51 AM

Simplest way 

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
360 Views