Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Same structured tables get auto concatenated in qlik. Try placing a NOCONCATENATE between two loads like:
t1:
Load * from <>;
NoConcatenate
t2:
Load * from <>;
Thank you I did not know that.
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.
Only action listed is mark as helpful.
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.
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.