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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sushantk19
Creator
Creator

how to get a value within same group

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.

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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.

View solution in original post

2 Replies
TRF
Champion II
Champion II

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
Creator
Creator
Author

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