Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ganshyam
Creator II
Creator II

Split rows with unique records into multiple files

Hello,

 

I have input records sets in below format.

Headerdata
a,b,c,d1,2,3,4
e,f,g11,22,33
a,b,c,d5,6,7,8
a,b,c,d9,10,11,12
a,b,c,d13,14,15,16
e,f,g44,55,66

 

Here Header has a,b,c,d and e,f,g as unique records, 

Expected output.

2 different output files of a,b,c,d and e,f,g with below format records.

Here the data is below the unique header.

 

a,b,c,d
1,2,3,4
5,6,7,8
9,10,11,12
13,14,15,16

 

e,f,g
11,22,33
44,55,66

 

Regards

Labels (3)
1 Solution

Accepted Solutions
Ganshyam
Creator II
Creator II
Author

Hello,

Thank you for your reply!!

I tried the below solution and it worked.

0683p000009M9yl.png

 

Attached are the component configuration settings.

 

Regards


tuniq_config.PNG
tmap_config.PNG
tnormalize_config.PNG

View solution in original post

2 Replies
Anonymous
Not applicable

Hi,

 

too difficult to explain how to process so i made the job for you :

replace content by data 

0683p000009M9pl.png0683p000009M9hM.png0683p000009M9yM.png0683p000009M9yR.png

Ganshyam
Creator II
Creator II
Author

Hello,

Thank you for your reply!!

I tried the below solution and it worked.

0683p000009M9yl.png

 

Attached are the component configuration settings.

 

Regards


tuniq_config.PNG
tmap_config.PNG
tnormalize_config.PNG