Transform durring QVD load

An qvd file is an compressed Qlikview Table and it can only store one Table file.
If you want to save more than one table into one qvd you must join or concatenate them into one table before you store them.

Because the qvd file is compressed it could happen that fields get empty if you modify other fileds during the load of the qvd.

See also Reference Manual: "Optimized mode can be utilized only when all loaded fields are read without any transformations..."

Example:
1.      LOAD
2.      field,
3.      num(field2) As numeric_field2
4.      FROM BKPF.QVD (qvd);

The best practice in this case would be to doing the stuff from line 3 (in the example above) during the qvd generation and not after.

Otherwise you must doing a Resident Load which can slow down your complete Performance and also can impact the RAM usage.

Example:
1.      Test:
2.      LOAD
3.      field,
4.      field2
5.      FROM BKPF.QVD (qvd);

6.      LOAD
7.      field,
8.      num(field2) As numeric_field2
9.      Resident Test;

10.    Drop Table Test;