Skip to Content
Apr 22, 2020 at 11:11 PM

How to add a Hash function in a Calculated Column

227 Views Last edit Apr 23, 2020 at 05:33 AM 2 rev


Currently we are following this process:

1. Create Cal View. Here, we consolidate three data sources.

2. Create TUDF using the above fields. Here we need to apply HASH_SHA256 function. WE cannot invert the process.

3 Create final Cal View using the the above objects.

My question to you all is this: how can I implement the above HASH function in a calculated column? if this is possible, we will save some time in the project.

I will be happy for any idea.