topic AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem in QlikView

AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

Tue, 30 Oct 2012 22:14:27 GMT

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

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

Wed, 13 Feb 2013 10:02:10 GMT

Hai this is Rams

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

Ram

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

swuehl — Wed, 13 Feb 2013 11:10:52 GMT

Marcos,

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

Re: AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

perumal_41 — Wed, 13 Feb 2013 11:19:38 GMT

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.