I have many tables with Branches and different periods. For concatenate them Im using Autonumber Fuction but When QlikView concatenate the tables the results are differents that when I load QVDs Separately. I left an example file with Oct 2012. The real result in my Qvd is 22.262.560. The example Rec Castigo Gives me Diferent 8876479.
If I remember correctly the autonumber function only guarantee unique values for anything processed during execution of the load script. The counter is reset to 1 on every reload. So it could well generate different numbers for the same concatenation in different reloads. You should not store autonumber keys in the qvd if you create the qvd's separately. Store the original data in the qvd's and create the autonumber keys when you load the qvd's.
I stored the original data in my Qvds. And the I create the autonumber inside the Qvds created. If I understood well you mean that I Should be create the autonumber before of store?
If you look at the sample that I put here. You can see that I have the same structure that your example. Just that Im using concatenate. look at the sheet "Union2".
