Share via

Transformations in Data Flow

Sneha Ray 26 Reputation points
2022-05-31T13:34:12.603+00:00

I am performing mapping in data flow in Azure. The table on the left contains 2 columns with multiple values. I want the output to look like the Result table in which the 1st value of the subject column should be paired with the 1st value of the Marks column, and so on and so forth. What transformations can be done in DATA FLOW to achieve the desired result table?

207117-731fe93d-4c57-43b3-b6d7-4b5a317a45ed.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. Nasreen Akter 10,891 Reputation points Volunteer Moderator
    2022-05-31T15:40:52.397+00:00

    Hi @Sneha Ray ,

    Would you please try the following. Thanks!

    _pairs keyValues(split(Subject, ','), split(Marks,','))
    _subject toString(unfold(split(Subject, ',')))
    _marks at({_pairs}, {_subject})

    207076-image.png
    207175-image.png
    207176-image.png
    207154-image.png

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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