topic Re: Script no error but not loading second table in QlikView

Script no error but not loading second table

paullawrence190 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Script no error but not loading second table

tresB — Wed, 28 Jun 2017 09:05:18 GMT

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

t1:

Load * from <>;

NoConcatenate

t2:

Load * from <>;

Re: Script no error but not loading second table

paullawrence190 — Wed, 28 Jun 2017 09:08:50 GMT

Thank you I did not know that.

Re: Script no error but not loading second table

ramasaisaksoft — Wed, 28 Jun 2017 09:26:36 GMT

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.

Re: Script no error but not loading second table

paullawrence190 — Wed, 28 Jun 2017 09:29:32 GMT

Only action listed is mark as helpful.

Re: Script no error but not loading second table

marcus_malinow — Wed, 28 Jun 2017 09:33:49 GMT

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.

Re: Script no error but not loading second table

kvanandan1 — Wed, 28 Jun 2017 12:31:36 GMT

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.