Discussion board where members can get started with QlikView.
I have a table with all the following fields:
Date (DD/MM/YYYY) / Expiration_Date (DD/MM/YYYY) / Total_1 / Expiration_Date_2 (DD/MM/YYYY) / Total_2
With this fields I need to show this table (which I've done and it's ok):
But now I need to add this other table to my previous table:
And then have the following, all in a single table:
Is there any way to do that?
Wouldn't a simple concatenation help with this? Or am I missing something in the question?
Load Date, Expiration_Date, Total from QVD;
Load Date, Expiration_Date_2 as Expiration_Date, Total_2 as Total from QVD;
you can concatenate or join your table to bring your data together. Please find followinh example.
LOAD Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total
28/3/2018, 18/1/2019, $ 2,29
28/3/2018, 18/1/2022, $ 2,29
28/3/2018, 3/4/2018, $ 2,35
28/3/2018, 2/7/2018, $ 2,35
28/3/2018, 3/10/2018 ,$ 2,35];
Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total
28/3/2018, 3/4/2018, $ 8,56
28/3/2018 ,4/4/2018, $ 9,06
28/3/2018, 11/5/2018, $ 9,93];
Load Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total inline [
IT is a simple question just rename the fields like table 1 by using alias it will auto- concatenate else you will do force concatenate r use join you will get one table as like your requirement