how to get a value within same group

[sushantk19]

Hi,

I have the below scenario:

Orders_ID   Flag1   flag2

100               Y          N

100               N          Y

100               N          N

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.

[TRF · Accepted solution]

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.

[sushantk19]

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