question

dirtyData-4787 avatar image
0 Votes"
dirtyData-4787 asked ShaikMaheer-MSFT commented

ADF Data Flow ColumnNames function issues

Hello,

I'm trying to generate a hash based on the drifted columns only in the data flow. I understand that the columnNames() function returns an array of columns names, but when I try and plug that into the md5() function it doesn't work. How can I use the columnNames function with functions like md5 or sha to generate a hash only on those fields?

 md5(columnNames('',true()))

204811-image.png









azure-data-factory
image.png (57.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @dirtyData-4787,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·
SubashriVasudevan-1752 avatar image
0 Votes"
SubashriVasudevan-1752 answered SubashriVasudevan-1752 edited

Hi @dirtyData-4787

Thanks for using Microsoft Q & A platform to post your query.

Right now we cannot pass an array to MD5 function.

Similar question has been discussed in the link
Please check let us know if it answers your questions or kindly revert for further questions on it.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered

Are you looking to hash the column names or column values? This will give you a full row fingerprint by hashing all columns: sha2(256,columns())

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.