Resident table loading problem-No table found

[#1]

I have two tables with same columns, (current years data and previous years data)

curr_year:

load a,b,c

from

curr_year_qvd.qvd(qvd);

Noconcatenate

//prev_year:

load a,b,c

from

prev_year_qvd.qvd(qvd);

yearly_data:

load a,b,c

resident curr_year;

inner join (yearly_data)

load c,d,e

from currency_dat.qvd(qvd);

ideally yearly_data table should give me consolidated result, but it gives me error while loading "table not found".

i want to take cosolidated result in one table and then join currency table with this cosilidated table.

How can i resolve this?

[jfkinspari]

The Yearly_data table is automatic concatenated to curr_year or prev_year (or whatever the table is called)

Include the Noconcatenate keyword.

[#3]

Use the below script. It should resolve the issue.

curr_year:

load a,b,c

from

curr_year_qvd.qvd(qvd);

prev_year:

load a,b,c

from

prev_year_qvd.qvd(qvd);

yearly_data:

Noconcatenate

load a,b,c

resident curr_year;

inner join (yearly_data)

load c,d,e

from currency_dat.qvd(qvd);

DROP Table curr_year;

Kranthikumar M

[ashfaq_haseeb]

Try below

curr_year:

load a,b,c

from

curr_year_qvd.qvd(qvd);

Noconcatenate

//prev_year:

load a,b,c

from

prev_year_qvd.qvd(qvd);

Noconcatenate

yearly_data:

load a,b,c

resident curr_year;

inner join (yearly_data)

load c,d,e

from currency_dat.qvd(qvd);

Regards

ASHFAQ

[jagan · Accepted solution]

Hi,

Give NoConatenate keyword to Yearly_data table to restrict auto concatenation.

curr_year:

load a,b,c

from

curr_year_qvd.qvd(qvd);

Noconcatenate

//prev_year:

load a,b,c

from

prev_year_qvd.qvd(qvd);

yearly_data:

Noconcatenate

load a,b,c

resident curr_year;

inner join (yearly_data)

load c,d,e

from currency_dat.qvd(qvd);

Regards,

Jagan.

[Anonymous]

hi,

Another no concatenate is required between prev_year and yearly_data

HTH

Ravi N.

[#7]

i tried , still not getting resolved

[#8]

Yes Jagan. i tried and its working now. Thanks

[#9]

Sorry , small correction, instead of NOconcatenation between two tables, it should be concatenation . else it will leads to synthetic keys, which will hamper our performance.

so it should be

Table A

a,b,c from table1;

concatenate

Table B

a,b,c from table2;

final_table:

Noconcatenate

load

a,b,c
resident TableA;