Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele_qlik
Contributor III
Contributor III

SAME KEY FIELD VALUES IN DIFFERENT APPS

Hi at all.

Suppose I have two table. First table is:

[

     Name,Age

     Jhon,18

     Mark,30

     Anne,25

]

Second Table is:

[

     Name,Nation

     Anne,Italy

     Carlos,Spain

     Jhon,Scotland

     Richard,U.S.A.

     Mark,Germany

]

Now I create two apps and I load first table in first app and second table in second app.

I want to create a key field with Name Field.

If I use autonumber function, in the first app, for example, Jhon has 1 value in autonmber field while in the second app he has 3 value in autonumber field.

If I use hash128 function, Jhon, Mark and Anne have same key field values in the first and in the second app but key field values are not numeric.

I want result of hash128 function but with numeric values.


IS THERE A METHOD?


P.s. AutonumberHash128() function in not correct

1 Reply
agigliotti
Partner - Champion
Partner - Champion

what are you trying to achieve?