topic Re: How to separate rows group by a column? in Talend Studio

How to separate rows group by a column?

Franz3 — Thu, 17 Dec 2015 10:09:23 GMT

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

Re: How to separate rows group by a column?

Anonymous — Fri, 18 Dec 2015 08:08:07 GMT

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 String)globalMap.get("row1.key")
value String)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

Re: How to separate rows group by a column?

Anonymous — Fri, 18 Dec 2015 16:36:50 GMT

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

Re: How to separate rows group by a column?

Anonymous — Mon, 21 Dec 2015 06:46:36 GMT

Hi,

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