how get fields from two tables using Resident Load

Tue, 23 Sep 2014 09:56:39 GMT

Hi Friends,

I have two table

Table 1 Table 2

A Z

B X

C Y

Now I have to create a new table taking values from Table1 and Table2

Can I use Resident Load for this

thanks

Re: how get fields from two tables using Resident Load

Tue, 23 Sep 2014 10:13:26 GMT

You probably want to use a CONCATENATE or JOIN statement?

When you have loaded tables 1 and 2 (using FROM statement), you can use RESIDENT after that, since they are present in memory.

Might be something like this ....

[Table 1]:

LOAD * FROM [Table 1 ...];

[Table 2]:

LOAD * FROM [Table 2 ...];

[Table 3]:

NOCONCATENATE

LOAD * RESIDENT [Table 1 ...];

LOAD * RESIDENT [Table 2 ...];

DROP TABLES [Table 1], [Table 2];

Don't forget the NOCONCATENATE in the sample above, or else the data from Table 1 is loaded twice in Table 1. QV recognizes that Table 1 and the resident load from Table 1 have exactly the same build, so they will be concatenated automatically, unless you use the NOCONCATENATE statement first.

topic how get fields from two tables using Resident Load in QlikView

how get fields from two tables using Resident Load

Re: how get fields from two tables using Resident Load