Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have 2 same tables with the same feilds (hist & now)
how can i load them for one table ?
thanks'
yarin.
Helli Yarin,
Try this,
Table1:
Load
Dimension1,
Dimension2
Form Table1;
Concatenate(Table1)
Table2:
Load
Dimension1,
Dimension2
Form Table2;
This will come automatically, Qlik engine can JOIN from 2 tables and club to one table as you need
If you want to keep them Separately after the load use the Qualify statement
Refer this post
Do you Qualify?- How to use QUALIFY statement
Use concatenate between two load statements