Internal Inconsistency

[spividori]

Hi.

I have a file .qvd. It contains 8.800.000 registers. To recharge my application I add the following:

Autonumber(C_ID&'-'&N_IT&'-'&V) as Key,

Autonumber(C_ID&'-'&N_IT) as Key1,

This generates the following error:

or the following:

Someone can help me solve it?

Regards.

[spividori]

Hi.

I tried to recharging discarding the "AutoNumber" function:
C_ID & "-" & N_IT & "-" & V as Key
C_ID & "-" & N_IT as Key1
There was no error, memory usage reached 1.3 gb.
Can it be that the "autonumber" requires a high memory usage?

Regards.

[Gysbert_Wassenaar]

Yes, the autonumber function can need a lot temporary space if the cardinality of C_ID&'-'&N_IT&'-'&V is high and your source data has a lot of records.

[spividori]

But it would be more efficient to use the "autonumber" function to the data model.

Is this so?

Regards.

[Gysbert_Wassenaar]

Because at the end you will have a qlikview document that is smaller and faster then you would have if you used the bare concatenated key. Calculating the autonumber values requires more ram only during the reload.

[spividori]

Ok, thank you very much for the clarification.

Regards.