Use HASH function on multiple columns

[PRelumyx1623183323]

Hi all,

I am searching for a HASH function I can use to HASH multiple columns of my database after a input. I know there is a component called tAddCRCRow, but the chances for a HASH collision are very high.

Is it possible to use MD5 or something like that instead?

Cheers!

[gjeremy1617088143]

Hi , you can use the function DataMasking.createMD5(your string) : Calculates MD5 hash value from String.

Send Me love and Kudos

[Papademuchos]

I realize this post is 2 years old - stumbled across it while looking for a new solution. It appears createMD5 was removed in Talend v8. Does anyone know of a new solution that would work like this one did?

[SamuelLenk]

Apache Commons Codec library has DigestUtils that you can use.

[jlolling_kloeckner]

You can do this with the help of this custom component: https://github.com/jlolling/talendcomp_tHashRow and you can download it from the release section on the right side.