Load 2 resident tables with an inner join witn NoConcatenate option

meysspi — Thu, 08 Jun 2023 17:08:11 GMT

I will link LOAD NoConcatenate 2 tables with an inner join on field PROJECT_PKID

TABLE_A_TEMP:

NoConcatenate
LOAD * Resident TABLE_A
WHERE LCM_HED_TP_CD='CNT';

DROP TABLE TABLE_A;

RENAME Table TABLE_A_TEMP to TABLE_A;

INNER JOIN (PROJECT_PKID) // table A and Table B have a common field PROJECT_PKID

TABLE_B_TEMP:

NoConcatenate
LOAD * Resident TABLE_B;

DROP TABLE TABLE_B;

RENAME Table TABLE_B_TEMP TO TABLE_B;

but the NoConcatenate doesn't work with the TABLE_B ,

If a delete NoConcatenate the script works but the Table B is concatenated to the Table A

Re: Load 2 resident tables with an inner join witn NoConcatenate option

Digvijay_Singh — Thu, 08 Jun 2023 21:10:01 GMT

TABLE_A_TEMP:

After inner join, we don't specify field name, its the first table we want to inner join with the upcoming table.

May be try like this -

NoConcatenate
LOAD * Resident TABLE_A
WHERE LCM_HED_TP_CD='CNT';

DROP TABLE TABLE_A;

RENAME Table TABLE_A_TEMP to TABLE_A;

INNER JOIN (TABLE_A) // table A and Table B have a common field PROJECT_PKID

LOAD * Resident TABLE_B;

The final output should be in Table_A.