topic Re: how to get a value within same group in Talend Studio

how to get a value within same group

sushantk19 — Sat, 16 Nov 2024 02:04:07 GMT

Hi,

I have the below scenario:

Orders_ID Flag1 flag2

100 Y N

100 N Y

100 N N

so basically for same order we have 4 rows, now in target i want to load a single row for order_id with flag1=Y and flag2=Y ,if one of the records have a Y flag. How can i achieve this result.

Re: how to get a value within same group

TRF — Wed, 24 Jun 2020 13:48:35 GMT

tAggregateRow with Orders_ID as "Group by" column and "max" (as Y is greater than N) as Function for both outpout column Flag1 and Flag2.

Re: how to get a value within same group

sushantk19 — Wed, 24 Jun 2020 15:05:45 GMT

@TRF : Thanks! I get the intended result. Thanks for the quick reply.