Cannot Join Two Tables After a Concatenate

[cristian_av]

Hi

I'm trying to do a join after a concatenation of some tables, but I'm getting the following: (The tables are not concatenating).

I've uploaded a reduced qvw file.

Maybe the file will be useful for somebody, because I'm trying to do a qvw to  do a data dictionary from the sys tables of a sql server.

Thanks!!

OLEDB CONNECT TO [Initial Catalog=Database1;Data Source=192.168.4.XX;];

[Tablas]:
LOAD
  DBName&SchemaName&TableName as LlaveTablasColumna
  ,DBName
...
SQL
Select
.....;

Join (Tablas)
LOAD
  DBName&SchemaName&TableName as LlaveTablasColumna
  ,[TableRowCount]
...
SQL
Select ....;



OLEDB CONNECT TO [Initial Catalog=Database2;Data Source=192.168.4.XX;];

[Tablas]:
LOAD
  DBName&SchemaName&TableName as LlaveTablasColumna
  ,DBName
...
SQL
Select
.....;

/*********** This Join is Not Working ******************/

Join (Tablas)
LOAD
  DBName&SchemaName&TableName as LlaveTablasColumna
  ,[TableRowCount]
...
SQL
Select ....;

[kaushiknsolanki · Accepted solution]

HI,

What you should do is first join the tables and then do the concatenate, something like below.

Table:

Load Key,* from Table1;

Left join(Table)

Load Key,* from Table2;

Temp:

Load Key,* From Table3;

Left(Temp)

Load Key,* from Table4;

Concatenate(Table)

Load * resident Temp;

Drop table Temp;

Regards,

Kaushik Solanki