Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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