topic Re: Resident table loading problem-No table found in QlikView

Resident table loading problem-No table found

Wed, 02 Jul 2014 09:31:24 GMT

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?

Re: Resident table loading problem-No table found

jfkinspari — Wed, 02 Jul 2014 09:37:26 GMT

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

Include the Noconcatenate keyword.

Re: Resident table loading problem-No table found

Wed, 02 Jul 2014 09:42:36 GMT

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

Re: Resident table loading problem-No table found

ashfaq_haseeb — Wed, 02 Jul 2014 09:43:26 GMT

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

Re: Resident table loading problem-No table found

jagan — Wed, 02 Jul 2014 09:45:52 GMT

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.

Re: Resident table loading problem-No table found

Anonymous — Wed, 02 Jul 2014 09:47:57 GMT

hi,

Another no concatenate is required between prev_year and yearly_data

HTH

Ravi N.

Re: Resident table loading problem-No table found

Wed, 02 Jul 2014 09:51:13 GMT

i tried , still not getting resolved

Re: Resident table loading problem-No table found

Wed, 02 Jul 2014 09:58:07 GMT

Yes Jagan. i tried and its working now. Thanks

Re: Resident table loading problem-No table found

Thu, 03 Jul 2014 08:50:35 GMT

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;