Single row shold populate instead of 3 in ADF

Raj0125 471 Reputation points

Hi Everyone,

I am looking for below requirement in adf data flows.


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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,170 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Nasreen Akter 10,656 Reputation points

    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!

  2. Raj0125 471 Reputation points

    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.

    0 comments No comments

  3. Raj0125 471 Reputation points

    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.

    0 comments No comments