topic LOAD JOIN Duplicate in QlikView

LOAD JOIN Duplicate

Mon, 18 Apr 2011 23:13:37 GMT

Hello,

Can someone help me understand how did the duplicate tables (see attached image - DailyTxns & DailyTxns-1) get populated into the diagram. This is causing the reload "JOIN" to take a very long time to join.

Is there a way to manually delete the duplicate tables and more control on the join?

Any pointer or blogspot would help me a lot. Thanks!

LOAD JOIN Duplicate

erichshiino — Mon, 18 Apr 2011 23:22:45 GMT

We need to check your script, but maybe you are counting on the automatic concatenate and it didn't work.

It works only if you have exactly the same fields.

If you don't have the same fields, you need to force the concatenation:

DAILYTX:

LOAD * FROM SOMEWHERE ;

CONCATENATE(DAILYTX)

LOAD * FROM SOMEWHERE_ELSE;