dataflow - branch - collect all fields to go to sink

arkiboys 9,641 Reputation points
2022-03-14T14:51:52.137+00:00

Hello,
in the screenshot below, I am getting data from .json file...
flatten24 has a-lot of the fields.
Now I would like to get other fields from flatten23,22,21 so that I have them all to put into sink.
How do I do this please?
Thank you

182848-image.png

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-15T15:42:42.7+00:00

    Hi @arkiboys ,

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

    As I understand ask here you are trying to combine columns from all flatten branches. Please correct me if my understanding is wrong.

    We should consider using Join transformation to join all these streams.

    Please note, while performing join there should be a common column between streams. If its not there, then may be consider using surrogate key transformation on streams and then join based on that column.

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

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

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest