Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

Hai this is Rams

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

Ram

MVP
MVP

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

Marcos,

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

Partner
Partner

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

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.