topic Re: Table not found error while using cross table and concatenate in QlikView

Table not found error while using cross table and concatenate

Rajeshhyd — Thu, 14 Oct 2021 00:11:29 GMT

Hi All,

Getting No table found table2 for the below script. Please help me resolve it

Table1:
CrossTable(Brd,Data,1)
sql
select
colum1,
column2
from table_B1
where condition
;

Table2:
CrossTable(Brd,Data,1)
sql
select
colum1,
column2
from table_B2
where condition
;

Availy:
load
Hash128(colum1,'Band',Brd) as ID,

colum2 as avail,
'Inter State' as Source,
Brd,
Data
Resident Table1;
Concatenate(Availy)

load
Hash128(colum1,'Band',Brd) as ID,
colum1 as avail,
' State' as Source,
Brd,
Data
Resident Table2;

store Availy into $(pQVDPath)Availy.qvd;

drop table Table1,Table2;

Re: Table not found error while using cross table and concatenate

MarcoWedel — Thu, 14 Oct 2021 21:16:24 GMT

Both crosstable loads generate identical table structures (i.e. the resulting tables have columns 'colum1', 'Brd' and 'Data') and thus are auto concatenated. Hence Table2 is never created and therefore cannot be referenced.

hope this helps

Marco

Re: Table not found error while using cross table and concatenate

Rajeshhyd — Fri, 15 Oct 2021 01:31:52 GMT

I am doing resident load Table1, Table2 to modify the column data and try to load into new table and then load it to a QVD.

Availy:
load
Hash128(colum1,'Band',Brd) as ID,

How can i resolve in this case