topic Inner Join and Concatenate in QlikView

Inner Join and Concatenate

Fri, 23 Apr 2010 15:14:59 GMT

Data is currently being pulled from two locations. For instance, there is an Items table USA and Europe and Orders table USA and Europe.

In order to create one items table and one orders table I must perform concatenations to combine data from both databases.

Afterward I want to perform and inner join on tables Items and Orders, but am not able to due to concatenations.

ItemTable:

Load

ItemID,

'USA' As Loc;

SQL Select *

From Items;

Concatenate(ItemTable)

Load

ItemID,

'EU' As Loc;

SQL Select *

From Items;

Inner Join (ItemTable)

OrderTable:

Load

OrderID,

ItemID;

SQL Select *

From Orders;

Concatenate(OrderTable)

Load

OrderID,

ItemID;

SQL Select *

From Orders;

This code does not seem to work though. Any suggestions would be greatly appreciated.

Inner Join and Concatenate

spsrk_84 — Mon, 26 Apr 2010 06:23:53 GMT

Hi,

1) Convert the Orders Table and Items into Qvd's and then do the inner join but before that drop the actual raw database tables.

2) Else while fetching the data from database tables itself do the union operation on tables

Load

ItemID,

LOC;

Select ItemID,Loc from Items

union

Select ItemID,Loc from Items

Try the above two steps hope ur problem will be resolved.

Inner Join and Concatenate

Mon, 26 Apr 2010 13:22:52 GMT

Thank you... I will try the qvd approach and let you know my results.

Inner Join and Concatenate

Fri, 07 May 2010 20:40:20 GMT

Just wanted everyone to know this worked... Thank you to everyone for their help.

Inner Join and Concatenate

Fri, 07 May 2010 20:41:41 GMT

Just wanted everyone to know that the QVD approach worked wonders. Thank you everyone.