I have 2 qvds: order_200901.qvd and order_200902 with the same structure, code and value. when I read through the load order * from *. QVD; QlikView puts the name of the table before each field. I need that the fields have the same table name in all fields. Example
[tab1]: load * from order_*;
//// in this case the field are ///// order_200901.codigo ////// order_200902.codigo
store tab1 into tab1;
drop table;
[order]: qualify *;
load * from tab1; //// in this case the field are ///// order.codigo
with this I have to read 2 times to reach my goal. is that right?