Single row shold populate instead of 3 in ADF

Raj0125 511 Reputation points
2022-04-28T14:12:15.39+00:00

Hi Everyone,

I am looking for below requirement in adf data flows.

197377-image.png

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.
10,995 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Nasreen Akter 10,801 Reputation points
    2022-04-28T19:44:29.623+00:00

    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 511 Reputation points
    2022-04-29T04:59:48.367+00:00

    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 511 Reputation points
    2022-04-29T12:51:31.967+00:00

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

    sample here

    197821-image.png

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.