Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paullawrence190
Contributor
Contributor

Script no error but not loading second table

Hi all,

I have a fairly simple script that loads in two table with exactly the same structure and file names.

Despite what I try Qlik only loads first table.

I have tired naming them So table 1: Table 2: ect  and putting on separate tab.

I dont get any errors and if swap tables around again only first one loads.

Any ideas?

6 Replies
tresesco
MVP
MVP

Same structured tables get auto concatenated in qlik. Try placing a NOCONCATENATE between two loads like:

t1:

Load * from <>;

NoConcatenate

t2:

Load * from <>;

paullawrence190
Contributor
Contributor
Author

Thank you I did not know that.

ramasaisaksoft

Hi Paul,

By default Qlikview will fallow either Auto Concatenate or Full Outer Join

-->so if all the fields are same Auto concatenate will happen

-->If 1 common field is there then Full outer join will happen

If you feel you got solution for your query please close the thread by clicking "Correct Answer" on Right hand side of your query.

paullawrence190
Contributor
Contributor
Author

Only action listed is mark as helpful.

marcus_malinow
Specialist III
Specialist III

Full outer join?

Er no it won't. It will associate two separate tables using the common field. A Full Outer Join is where you end up combining two tables into a single table.

kvanandan1
Creator
Creator

Hi Paul,

You can use QUALIFY *, before the load and see the tables will be loaded separetely.

After the load pls have UNQUALIFY *;

This way you can unassociate the common link btw the fields in the table.