Re: 2 same tables - Qlik Community

Anonymous · ‎2017-09-10

hi,

i have 2 same tables with the same feilds (hist & now)

how can i load them for one table ?

thanks'

yarin.

rohitraut · ‎2017-09-10

Helli Yarin,

Try this,

Table1:

Load

Dimension1,

Dimension2

Form Table1;

Concatenate(Table1)

Table2:

Load

Dimension1,

Dimension2

Form Table2;

Anil_Babu_Samineni · ‎2017-09-10

This will come automatically, Qlik engine can JOIN from 2 tables and club to one table as you need

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-09-10

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

qlikviewwizard · ‎2017-09-10

Use concatenate between two load statements