Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

Hi Dear QV Comnunity

I have a problem when I try to apply the function AutoNumberon a key that is in two tables from two different source types, but contain the same string, I quote an example

Country --->%KeyAccount

Information from a table in Oracle by concatenating a key 230320430_2010_08

Load AutoNumber (KeyAccount & "_" & Year & '_' Month) As %KeyAccount

           , Other fields;

SELECT KeyAccount, Year, Month, Other Fields

FROM ORACLE_TABLE

Transaccion--->%KeyAccount

Information from an Excel spreadsheet by concatenating a key 230320430_2010_08

Load AutoNumber (KeyAccount & "_" & Year & '_' Month)   As %KeyAccount

           , Other fields;

FROM BOOK.XLS;

My problem is that in both cases I get a different result

Country --->%KeyAccount = 1234

Transaccion--->%KeyAccount = 83121

I tried with AutoNumber, AutoNumberHash128 and AutoNumberHash256 include the 2nd,3rd ... parameters

AutoNumberHashXXX (KeyAccount, Year,Month )

AutoNumberHashXXX (KeyAccount, Year,Month,KeyAccount & "_" & Year & '_' Month )

AutoNumberHashXXX (KeyAccount& "_" , Year & "_" ,Month,KeyAccount & "_" & Year & '_' Month )

But not work

3 Replies
Not applicable
Author

Hai this is Rams

i think this is very helpful.... thnak you

Ram

swuehl
MVP
MVP

Marcos,

are you calculating your autonumber() keys in the same or in different qvw applications?

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Marcos,

first put   Transaction table   .then Country table in script .after reload your qvw applications .

i don't know my idea is working or not ,but once try.