Cannot Join Two Tables After a Concatenate

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

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 ....;

Re: Cannot Join Two Tables After a Concatenate

kaushiknsolanki — Thu, 13 Jul 2017 15:29:19 GMT

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

topic Re: Cannot Join Two Tables After a Concatenate in QlikView

Cannot Join Two Tables After a Concatenate

Re: Cannot Join Two Tables After a Concatenate