This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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()))
Hi @dirtyData ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hi @dirtyData
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.
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())