topic LOAD concatenates to wrong table in QlikView

LOAD concatenates to wrong table

jcarpenter9 — Wed, 20 May 2009 21:53:01 GMT

I'm scratching my head over this. The script loads 6 fields from QVD files into Table1. Next, it loads 100 more rows from a BIFF file into Table2, with the same field names. NOCONCATENATE is specified for the second load.

An interim step modifies the data in Table2, leaving it with the same 6 field names.

Finally, it uses CONCATENATE (Table1) LOAD * RESIDENT Table2 to merge the two tables.

The problem? This last LOAD concatenates the data back onto Table2, even though the script specified "CONCATENATE (Table1)".

Why would QlikView insist on concatenating data to a table different from the one that is specified? I have a workaround (add all the interim processing into the second load statement, making it concatenate to Table1), but I need to understand what is causing this.

LOAD concatenates to wrong table

Thu, 08 Oct 2009 13:33:42 GMT

i am having the same issue. The Concatenate load will insist on loading onto itself much like yours. Have you found a better solution or the reason for this?

LOAD concatenates to wrong table

Mon, 09 Nov 2009 22:38:57 GMT

Hi,

I had the same problem and just by switching the order the problem was resolved. I have no explanantion for this.

So instead of CONCATENATE (Table1) LOAD * RESIDENT Table2 ,

try CONCATENATE (Table2) LOAD * RESIDENT Table1

LOAD concatenates to wrong table

Tue, 10 Nov 2009 03:32:38 GMT

I have noticed the same thing as Kristof and when I had this problem I just had to flip the order and all of a sudden it worked.

LOAD concatenates to wrong table

jcarpenter9 — Tue, 10 Nov 2009 03:51:50 GMT

Thank you both for replying. I'll try this next time I encounter the problem.

James