Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
The Yearly_data table is automatic concatenated to curr_year or prev_year (or whatever the table is called)
Include the Noconcatenate keyword.
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;
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
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.
hi,
Another no concatenate is required between prev_year and yearly_data
HTH
Ravi N.
i tried , still not getting resolved
Yes Jagan. i tried and its working now. Thanks
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;