Single row shold populate instead of 3 in ADF

Question

Hi Everyone,

I am looking for below requirement in adf data flows.

Instead of 3 rows i need to populate in a single row.

Answer 1

Hi @Raj0125 ,

Thank you for the ask. In the Dataflow, you can try Aggregate transformation where you can do GroupBy by Date and aggregates each field like first(fieldName, true()) . Hope this helps. Thanks!

Answer 2

Thanks for suggestion.

But my expected result set is as below

Suppose jan 1 st is holiday for all 3 regions my output should be

01012022 Y Y Y

But my result are showing as

01012022 Y N N

I have use case statement before aggregator to derive indicators based on Region name

case when region = US Y N

case when .......son on to get indicator values.

Pls suggest.

Answer 3

Thank for your response ..I have implemented same logic. But there is some thing wrong in fetching.

sample here

I am getting US values is correct but Australia indicator in yellow highlighted showing wrong.

I derived these Holiday_Indicator columns based on Region using case statment to get Holiday inicators.