CODEWITHSUNDEEP
azureazure-data-factory
Rishikesh Darwade
Rishikesh Darwade

Reputation: 11

How to use Binary column to JOIN in Azure Data Factory?

I am creating a dataflow in Azure Data Factory . I have to join two Data source on a column which is binary (VARBINARY(MAX)). The validation shows me this error : Expression's type 'binary' is not compatible with left side expression's type 'binary'

How to JOIN using binary in ADF JOINS ? Validation Error on JOIN Binary column

Upvotes: 0

Views: 479

Answers (1)

Rishikesh Darwade
Rishikesh Darwade

Reputation: 11

I solved this by using function hex()

JOIN on hex(column1) == hex(column2).

Upvotes: 1

Related Questions