load * from tab_*;

Fri, 06 Nov 2009 09:01:57 GMT

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?

load * from tab_*;

disqr_rm — Fri, 06 Nov 2009 09:04:13 GMT

What is you use "UnQualify *;" before you load [tab1] first time?

load * from tab_*;

Fri, 06 Nov 2009 09:16:14 GMT

I think it will really solve. thanks.

topic load * from tab_*; in QlikView

load * from tab_*;

load * from tab_*;

load * from tab_*;