CODEWITHSUNDEEP
sqljoinazure-data-factory
user989988
user989988

Reputation: 3746

Filter in Azure Data Factory

I have 2 sources as follows:

enter image description here

I need to do a filter on Source 1 such that output contains only values with Colors except Green, Blue, Black:

enter image description here

This is how my data flow looks like:

enter image description here

Is there a different way to do this using a join with Source 2 Color?

Upvotes: 0

Views: 73

Answers (1)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

If you want to filter the person names based on color names, then you'll need to first join and then you can filter on color name.

Upvotes: 1

Related Questions