topic Re: Use HASH function on multiple columns in Talend Studio

Use HASH function on multiple columns

PRelumyx1623183323 — Sat, 16 Nov 2024 00:04:39 GMT

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!

Re: Use HASH function on multiple columns

gjeremy1617088143 — Wed, 09 Jun 2021 06:47:08 GMT

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

Send Me love and Kudos

Re: Use HASH function on multiple columns

Papademuchos — Mon, 27 Mar 2023 23:43:02 GMT

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?

Re: Use HASH function on multiple columns

SamuelLenk — Tue, 28 Mar 2023 09:17:22 GMT

Apache Commons Codec library has DigestUtils that you can use.

Re: Use HASH function on multiple columns

jlolling_kloeckner — Tue, 28 Mar 2023 18:45:47 GMT

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.