AutoNumber, AutoNumberHash128 and AutoNumberHash256 Problem

[#1]

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

[#2]

Hai this is Rams

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

Ram

[swuehl]

Marcos,

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

[perumal_41]

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.