Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Resident table loading problem-No table found

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.

8 Replies
jfkinspari
Not applicable

Re: Resident table loading problem-No table found

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

Re: Resident table loading problem-No table found

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

Re: Resident table loading problem-No table found

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

Re: Resident table loading problem-No table found

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.

ravic906
Not applicable

Re: Resident table loading problem-No table found

hi,

Another no concatenate is required between prev_year and yearly_data

HTH

Ravi N.

Not applicable

Re: Resident table loading problem-No table found

i tried , still not getting resolved

Not applicable

Re: Resident table loading problem-No table found

Yes Jagan. i tried and its working now. Thanks

Not applicable

Re: Resident table loading problem-No table found

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;