Problem with Resident Load.

[sinanozdemir]

Hi all,

I have the below data model:

I am sourcing these two tables from different servers and databases as follows:

ODBC CONNECT32 TO [DatabaseA];

Claims:

ODBC CONNECT32 TO [DatabaseB];

Referrals:

In another tab, when I try to create a temp table via resident load from Claims, and dropping Claims and Referrals table. I end up with nothing.

Temp:

LOAD

  *

Resident Claims;

Drop Tables Claims, Referrals;

Any ideas why I am not getting anything after running the above script.

Thanks

[ankit777 · Accepted solution]

Hi

Use NOCONCATENATE before Temp table

[fvelascog72]

Hi,

Why you load Referals and later erase it?

You can use Noconcatenate before load Temp table.

[sinanozdemir]

Thanks a lot.

It worked..

[ankit777]

cheers...

[#6]

Hi,

I think Ankit is correct, if you have two tables with the exact same field names will the two tables merge (and be named after the first one in the list. One option as told is to use NOCONCATENATE to stop this from happening or you can add a temporary dummy field in the temp table

Ex

Temp:

Load

*,

'dummy' as _tempfield

Resident Claims;

Good luck!

[sinanozdemir]

This worked as well.

Thank you Hampus.