Union from 2 sources

Vineet S 750

Hi how union will work in adf from 2 sources without dataflow

Nandan Hegde 32,026 Reputation points MVP

2024-08-23T05:39:29.53+00:00
Can you be more specific with your ask here like :

what does your source data look like ? Is it an array?
Plz provide some sample data /screenshot

You want to do union between those 2 sources to get unique value?
Do you have a SQL database in your ecosystem?
PRADEEPCHEEKATLA-MSFT 88,876 Reputation points Microsoft Employee

2024-08-28T10:49:14.7433333+00:00

@Vineet S - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

PRADEEPCHEEKATLA-MSFT 88,876 Reputation points Microsoft Employee

2024-08-23T05:48:46.7466667+00:00

@Vineet S - Thanks for the question and using MS Q&A platform.

Union transformation in Azure Data Factory (ADF) is used to combine multiple data streams into one, without needing to have a join key. However, it is only available in Mapping Data Flows in ADF.

For more details, refer to Union transformation in mapping data flow and this article contains a short video walk-through of the union transformation in the mapping data flow.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer