Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resident table loading problem-No table found

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?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

8 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

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

Include the Noconcatenate keyword.

Not applicable
Author

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
Champion III
Champion III

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
Luminary Alumni
Luminary Alumni

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
Not applicable
Author

hi,

Another no concatenate is required between prev_year and yearly_data

HTH

Ravi N.

Not applicable
Author

i tried , still not getting resolved

Not applicable
Author

Yes Jagan. i tried and its working now. Thanks

Not applicable
Author

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;