topic Re: resident load con-cat. in QlikView

resident load con-cat.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a issue with concatenating two tables of different data base,please try to resolve it.

Table A is from data base which i loaded from include files and Table B is loaded from excel file,

i need to concatenate this two tables such That Table B fields should reflect in Table A.

i need to use resident load to do this and i don't have much knowledge on resident load.

Thanks in advance.

sunny_talwar — Thu, 24 Mar 2016 10:32:09 GMT

Can you share your current script? So that we can give specific instructions?

amayuresh — Thu, 24 Mar 2016 11:29:20 GMT

This may help you to understand the Resident Load and Concatenate,

[Table 1]:

LOAD * FROM [Table 1 ...];

[Table 2]:

LOAD * FROM [Table 2 ...];

[Table 3]:

NOCONCATENATE

LOAD * RESIDENT [Table 1 ...];

<CONCATENATE / JOIN>

LOAD * RESIDENT [Table 2 ...];

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

Anonymous — Thu, 24 Mar 2016 11:38:27 GMT

Table A:

load * from include file;

Table B:

load * from excel;

Table C:

noconcatenate

load * resident Table A;

Drop table Table A:

Concatenate

laod * resident Table B;

Drop table Table B: