topic Re: Joining two tables in QlikView

Joining two tables

samvile18 — Wed, 05 Feb 2014 13:58:34 GMT

Good afternoon everyone,

Can someone me please? I'm trying to join two exact tables together to make one master, I'm struggling with the script though.

I have the following:

ItemsOut:

LOAD DATE,

CRDATE

CRTIME,

NODE,

MEASURE

SQL SELECT *

FROM FPWFI;

I then have the same script to load the ItemsIn table, the main difference is the measure says Pipeline in one table and Outs in the other. How can I can add the Outs to the Pipeline so I end up with one master table showing both measures?

Re: Joining two tables

Nicole-Smith — Wed, 05 Feb 2014 14:01:21 GMT

Items:

LOAD DATE,

CRDATE

CRTIME,

NODE,

MEASURE;

SQL SELECT *

FROM FPWFI;

Concatenate(Items)

LOAD DATE,

CRDATE

CRTIME,

NODE,

MEASURE;

SQL SELECT *

FROM YourSecondSQLTable;

Re: Joining two tables

Wed, 05 Feb 2014 19:25:12 GMT

Hi Sam,

I suggest to save each table (Items In, Items Out) in a different QVD then when you will load them as a single table use a flag to recognize them.

The other option is doing the next select

Items:

LOAD DATE,

CRDATE

CRTIME,

NODE,

MEASURE,

'ITEMS OUT' as ITEMTYPE;

SQL SELECT *

FROM FPWFI;

concatenate

LOAD DATE,

CRDATE

CRTIME,

NODE,

MEASURE,

'ITEMS IN' as ITEMTYPE;

SQL SELECT *

FROM ItemsInSQLTable;