Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Autonumberhash128

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.

Labels (1)
3 Replies
brindlogcool
Creator III
Creator III
Author

Hi,

I am able to fix it.

swuehl
Champion III
Champion III

Maybe you want to use

...

Exists(Key,autonumberhash128(C1));

in your last load?

brindlogcool
Creator III
Creator III
Author

Thanks SwuehI,

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