Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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