topic Re: Autonumberhash128 in QlikView

Autonumberhash128

brindlogcool — Mon, 06 Feb 2012 15:24:40 GMT

Hi,

I have two tables T1,T2 with the link key combination of Number,Special Character.

I am trying to convert the key using Autonumberhash128 and the second table T2 should have the data based on the first table.

To get the above i was using the Exsists .But i am able to see all the values in the table T2 irrespective of T1. I want table T2 based on T1

Attached the sample file for your reference.

brindlogcool — Mon, 06 Feb 2012 16:12:55 GMT

Hi,

I am able to fix it.

swuehl — Mon, 06 Feb 2012 16:19:24 GMT

Maybe you want to use

...

Exists(Key,autonumberhash128(C1));

in your last load?

brindlogcool — Mon, 06 Feb 2012 16:39:28 GMT

Thanks SwuehI,

It was helpful i have resolved but reloading table T2 twice. Now it is fixed from your sample file.