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: 
rakeshpaul
Partner - Contributor
Partner - Contributor

Truncating and keeping data in different rows for a single ID

Hi All,

I have a data set like bellow mentioned -

IDNo
1AA751485:AA750402:AA750402:AA2503271:AA751716
2MBJ-AA3EM1

And I want the Output as below-

IDNo
1AA751485
1AA751485
1AA750402
1AA2503271
1AA751716
2MBJ-AA3EM1

Can you please help me in getting this sorted.

Regards,

Rakesh Paul

1 Reply
sunny_talwar

Try this:

Table:

LOAD ID,

     SubField(No, ':') as No

FROM

[https://community.qlik.com/thread/237520]

(html, codepage is 1252, embedded labels, table is @1);

Capture.PNG