LOAD JOIN Duplicate

[#1]

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!

[erichshiino]

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;