Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The easy way is to assign a sequence number for each group and separate the data based on the sequence number value in output section.
In normal case, you will have sequence like below
Numeric.sequence("s1", 1, 1)
But in your case, add your primary key as the factor to determine the sequence. But make sure that id value is in String format.
Numeric.sequence(row1.id, 1, 1)
Once you get a sequence number, you can control the flow by adding filter condition in output by checking the reminder of sequence value. For a three way sequence, you need to take the reminder of row1.seq%3 and check it as 0,1 or 2.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Hi,
I would say, do the split first using tnormalize and then group them.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂