Table not found error while using cross table and concatenate

[Rajeshhyd]

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;

[MarcoWedel]

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

[Rajeshhyd]

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,

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;

How can i resolve in this case