dataflow - joining flattened fields

arkiboys 9,641 Reputation points
2022-03-15T07:40:49.727+00:00

Hi,
I am flattening a json file data...
I am using flatten activity for each array inside a parent....
Basically, when I am happen with the flatten activies and I can see the columns coming through in each flatten activity, how do I put these fields from all the flattened activities into one sink?
Is it to use select activity after each flatten activity and then join them all using the parent fields?
Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,600 questions
0 comments
Accepted answer
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-03-16T11:47:33.887+00:00

    Hi @arkiboys ,

    Thank you for posting query in Microsoft Q&A Platform.

    As per my understanding it seems you are trying to join column from different flatten transformations together. Kindly correct me if I am wrong.

    We should consider using join transformation to join column from different streams. Please check below screenshot for high level idea.

    183753-image.png

    Please check below link where similar issue discussed.
    https://learn.microsoft.com/en-us/answers/questions/771356/index.html

    Hope this helps. Please let us know if any further queries.

    -------------------

    Please consider hitting Accept Answer button. Accepted answers helps communicate as well.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest