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

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Split File group by...

Hello,
I have to split a delimited file containing data like :

A;data1
A;data2
A;data3
B;data4
B;data5
I want to split this file to have 2 files (names A.csv and B.csv) containing :
File A.csv :
data1
data2
data3
and
File B.csv :
data4
data5

Someone can help ? Thank U in advance
Labels (2)
4 Replies
Anonymous
Not applicable
Author

You can use a tMap: create 2 output and filter the output on the first column, redirect your two outputs on two new csv files. This should do the trick.
Anonymous
Not applicable
Author

Thank You, i know how to do that.
I didn't explained enough : i don't know in my source file if i got just A and B, or A, or ABCDEF...
So i don't know how much files will be outputed...
Anonymous
Not applicable
Author

Just for my information, do you see my email adress as author of this post ?
Anonymous
Not applicable
Author

I have the same thing want to do? Do you find a solution?