topic Re: Problem with Resident Load. in QlikView

Problem with Resident Load.

sinanozdemir — Tue, 02 Jun 2015 13:45:11 GMT

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

Re: Problem with Resident Load.

ankit777 — Tue, 02 Jun 2015 13:47:09 GMT

Use NOCONCATENATE before Temp table

Re: Problem with Resident Load.

fvelascog72 — Tue, 02 Jun 2015 13:47:48 GMT

Hi,

Why you load Referals and later erase it?

You can use Noconcatenate before load Temp table.

Re: Problem with Resident Load.

sinanozdemir — Tue, 02 Jun 2015 13:49:08 GMT

Thanks a lot.

It worked..

Re: Problem with Resident Load.

ankit777 — Tue, 02 Jun 2015 13:50:06 GMT

cheers...

Re: Problem with Resident Load.

Tue, 02 Jun 2015 13:50:43 GMT

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

Temp:

Load

'dummy' as _tempfield

Resident Claims;

Good luck!

Re: Problem with Resident Load.

sinanozdemir — Tue, 02 Jun 2015 13:56:32 GMT

This worked as well.

Thank you Hampus.