CODEWITHSUNDEEP
azure-data-factory
Dan
Dan

Reputation: 141

Azure Data Factory Lookup Activity

I've got a Data Factory Lookup Activity The left (Primary) and right (Lookup Stream) side need to match on 4 columns to lookup a result. I've got;

toString(byName('Col1')) == toString(byName('Col1'))
toString(byName('Col2')) == toString(byName('Col2'))
...

I've also tried referencing the datasets

toString(byName('Col1','LeftSideDataset')) == toString(byName('Col1','RightSideDataset'))

When I preview the data in debugging I'm expecting those Columns to match, and the additional columns from the right to be added but they don't, they all seem to have matched the first row in the left input (without all of the matching criteria).

Has anyone experienced this?

Thanks, Dan

Upvotes: 1

Views: 610

Answers (2)

Dan
Dan

Reputation: 141

The data flow works as expected. The data wasn't showing as a Linked Service was altered so the data wasn't as expected.

Upvotes: 1

smotorious
smotorious

Reputation: 45

Hi Dan what settings did you use, I could not understand correctly , does anything Match from the Rightside or nothing ?

enter image description here

If only some match, might try it with the Match multiple rows or the Broadcasting

As the Debug shows only some examples of Data, it may occur that only the first lookup that hits is shown

enter image description here

Upvotes: 2

Related Questions