Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Items:
LOAD DATE,
CRDATE
CRTIME,
NODE,
MEASURE;
SQL SELECT *
FROM FPWFI;
Concatenate(Items)
LOAD DATE,
CRDATE
CRTIME,
NODE,
MEASURE;
SQL SELECT *
FROM YourSecondSQLTable;
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;