Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
pickery1
Creator
Creator

2 same tables

hi,

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

how can i load them for one table ?

thanks'

yarin.

4 Replies
rohitraut
Creator
Creator

Helli Yarin,

Try this,

Table1:

Load

Dimension1,

Dimension2

Form Table1;

Concatenate(Table1)

Table2:

Load

Dimension1,

Dimension2

Form Table2;

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion II
Champion II

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

qlikviewwizard
Master II
Master II

Use concatenate between two load statements