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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Franz3
Contributor III
Contributor III

How to separate rows group by a column?

Hi,
i have troubles finding the right component in my situation, help would be appreciate for a best practice developpement.
My schema is pretty simple (Key, Value), and i want to execute a job for each similar key.
for  exemple i want to transform this flow :
1 value1
1 value2
1 value3
2 value4
2 value5
3 value6
3 value7
in 3 flows 
1 value1
1 value2
1 value3
and 
2 value4
2 value5
and
3 value6
3 value7
simple as that 0683p000009MACJ.png

Labels (2)
3 Replies
Anonymous
Not applicable

Hi,
From your job description, you need to set a dynamic file path on tFileOutputDelimited component,  the job looks like:
tFileInputDelimited--row1--tFlowToIterate--tFixedFlowInput--main--tFileOutputDelimited(check out "Append"option?
on tFixedFlowOutput, generate the current data flow, define the same schema as tFileInputDelimited and set the values like:
column:value
key 0683p000009MPcz.pngString)globalMap.get("row1.key")
value 0683p000009MPcz.pngString)globalMap.get("row1.value")
On tFileOutputDelimited, set a dynamic file path, for example:
"D:/output/file"+(String)globalMap.get("row1.key")+".txt"
Best regards
Sabrina
Anonymous
Not applicable

Hello,
I want to increase the number of rows for Guess schema definition for File Delimited and File Position from metadata. How could I increase the number of rows which will be based on guess schema.

Thanks
snoor
Anonymous
Not applicable

Hi,

Please stick to your another topic: https://community.talend.com/t5/Design-and-Development/Increase-number-of-row-which-is-based-on-Gues... so that we can pay individule attention to it.
Best regards
Sabrina