Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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):
Date | Expiration_Date_1 | Total_1 |
---|---|---|
28/3/2018 | 19/1/2021 | $ 1,52 |
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 |
28/3/2018 | 31/12/2018 | $ 2,35 |
28/3/2018 | 2/4/2019 | $ 2,35 |
28/3/2018 | 1/7/2019 | $ 2,35 |
28/3/2018 | 2/10/2019 | $ 2,35 |
28/3/2018 | 30/12/2019 | $ 2,35 |
28/3/2018 | 30/3/2020 | $ 2,35 |
28/3/2018 | 30/6/2020 | $ 2,35 |
28/3/2018 | 30/9/2020 | $ 2,35 |
28/3/2018 | 30/12/2020 | $ 2,35 |
28/3/2018 | 30/3/2021 | $ 2,35 |
28/3/2018 | 30/6/2021 | $ 2,35 |
28/3/2018 | 30/9/2021 | $ 2,37 |
28/3/2018 | 10/10/2018 | $ 2,80 |
28/3/2018 | 28/5/2018 | $ 2,94 |
28/3/2018 | 28/8/2018 | $ 2,94 |
28/3/2018 | 28/11/2018 | $ 2,94 |
28/3/2018 | 28/2/2019 | $ 2,94 |
28/3/2018 | 28/5/2019 | $ 2,94 |
28/3/2018 | 28/8/2019 | $ 2,94 |
28/3/2018 | 28/11/2019 | $ 2,94 |
28/3/2018 | 27/2/2020 | $ 2,94 |
28/3/2018 | 27/5/2020 | $ 2,94 |
28/3/2018 | 27/8/2020 | $ 2,94 |
28/3/2018 | 30/11/2020 | $ 2,94 |
28/3/2018 | 25/2/2021 | $ 2,94 |
28/3/2018 | 26/5/2021 | $ 2,94 |
28/3/2018 | 26/8/2021 | $ 2,94 |
28/3/2018 | 29/11/2021 | $ 2,94 |
28/3/2018 | 23/2/2022 | $ 2,96 |
28/3/2018 | 20/1/2020 | $ 3,05 |
28/3/2018 | 16/4/2018 | $ 4,00 |
28/3/2018 | 23/5/2018 | $ 5,00 |
28/3/2018 | 25/6/2018 | $ 5,00 |
28/3/2018 | 25/7/2018 | $ 5,00 |
28/3/2018 | 26/10/2018 | $ 5,00 |
28/3/2018 | 19/7/2018 | $ 5,50 |
28/3/2018 | 17/8/2018 | $ 7,80 |
28/3/2018 | 11/5/2018 | $ 9,93 |
28/3/2018 | 23/4/2018 | $ 10,00 |
28/3/2018 | 4/6/2018 | $ 12,00 |
28/3/2018 | 27/4/2018 | $ 18,00 |
28/3/2018 | 5/9/2018 | $ 20,00 |
But now I need to add this other table to my previous table:
Date | Expiration_Date_2 | Total_2 |
---|---|---|
28/3/2018 | 3/4/2018 | $ 8,56 |
28/3/2018 | 4/4/2018 | $ 9,06 |
28/3/2018 | 11/5/2018 | $ 9,93 |
And then have the following, all in a single table:
Date | Expiration_Date | Total |
---|---|---|
28/3/2018 | 19/1/2021 | $ 1,52 |
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 |
28/3/2018 | 31/12/2018 | $ 2,35 |
28/3/2018 | 2/4/2019 | $ 2,35 |
28/3/2018 | 1/7/2019 | $ 2,35 |
28/3/2018 | 2/10/2019 | $ 2,35 |
28/3/2018 | 30/12/2019 | $ 2,35 |
28/3/2018 | 30/3/2020 | $ 2,35 |
28/3/2018 | 30/6/2020 | $ 2,35 |
28/3/2018 | 30/9/2020 | $ 2,35 |
28/3/2018 | 30/12/2020 | $ 2,35 |
28/3/2018 | 30/3/2021 | $ 2,35 |
28/3/2018 | 30/6/2021 | $ 2,35 |
28/3/2018 | 30/9/2021 | $ 2,37 |
28/3/2018 | 10/10/2018 | $ 2,80 |
28/3/2018 | 28/5/2018 | $ 2,94 |
28/3/2018 | 28/8/2018 | $ 2,94 |
28/3/2018 | 28/11/2018 | $ 2,94 |
28/3/2018 | 28/2/2019 | $ 2,94 |
28/3/2018 | 28/5/2019 | $ 2,94 |
28/3/2018 | 28/8/2019 | $ 2,94 |
28/3/2018 | 28/11/2019 | $ 2,94 |
28/3/2018 | 27/2/2020 | $ 2,94 |
28/3/2018 | 27/5/2020 | $ 2,94 |
28/3/2018 | 27/8/2020 | $ 2,94 |
28/3/2018 | 30/11/2020 | $ 2,94 |
28/3/2018 | 25/2/2021 | $ 2,94 |
28/3/2018 | 26/5/2021 | $ 2,94 |
28/3/2018 | 26/8/2021 | $ 2,94 |
28/3/2018 | 29/11/2021 | $ 2,94 |
28/3/2018 | 23/2/2022 | $ 2,96 |
28/3/2018 | 20/1/2020 | $ 3,05 |
28/3/2018 | 16/4/2018 | $ 4,00 |
28/3/2018 | 23/5/2018 | $ 5,00 |
28/3/2018 | 25/6/2018 | $ 5,00 |
28/3/2018 | 25/7/2018 | $ 5,00 |
28/3/2018 | 26/10/2018 | $ 5,00 |
28/3/2018 | 19/7/2018 | $ 5,50 |
28/3/2018 | 17/8/2018 | $ 7,80 |
28/3/2018 | 11/5/2018 | $ 9,93 |
28/3/2018 | 23/4/2018 | $ 10,00 |
28/3/2018 | 4/6/2018 | $ 12,00 |
28/3/2018 | 27/4/2018 | $ 18,00 |
28/3/2018 | 5/9/2018 | $ 20,00 |
28/3/2018 | 3/4/2018 | $ 8,56 |
28/3/2018 | 4/4/2018 | $ 9,06 |
28/3/2018 | 11/5/2018 | $ 9,93 |
Is there any way to do that?
Thank you!!!
Wouldn't a simple concatenation help with this? Or am I missing something in the question?
Table:
Load Date, Expiration_Date, Total from QVD;
concatenate (Table)
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.
Script:-
Table:
LOAD Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total
Inline [Date,Expiration_Date_1,Total_1
28/03/2018,19/01/2021,$1,52
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];
Concatenate
Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total
Inline [Date,Expiration_Date_2,Total_2
28/3/2018, 3/4/2018, $ 8,56
28/3/2018 ,4/4/2018, $ 9,06
28/3/2018, 11/5/2018, $ 9,93];
UI:-
Table1:
Load Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total inline [
Date | Expiration_Date_1 | Total_1 |
---|---|---|
28/3/2018 | 19/1/2021 | $ 1,52 |
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 |
28/3/2018 | 31/12/2018 | $ 2,35 |
28/3/2018 | 2/4/2019 | $ 2,35 |
28/3/2018 | 1/7/2019 | $ 2,35 |
28/3/2018 | 2/10/2019 | $ 2,35 |
28/3/2018 | 30/12/2019 | $ 2,35 |
28/3/2018 | 30/3/2020 | $ 2,35 |
28/3/2018 | 30/6/2020 | $ 2,35 |
28/3/2018 | 30/9/2020 | $ 2,35 |
28/3/2018 | 30/12/2020 | $ 2,35 |
28/3/2018 | 30/3/2021 | $ 2,35 |
28/3/2018 | 30/6/2021 | $ 2,35 |
28/3/2018 | 30/9/2021 | $ 2,37 |
28/3/2018 | 10/10/2018 | $ 2,80 |
28/3/2018 | 28/5/2018 | $ 2,94 |
28/3/2018 | 28/8/2018 | $ 2,94 |
28/3/2018 | 28/11/2018 | $ 2,94 |
28/3/2018 | 28/2/2019 | $ 2,94 |
28/3/2018 | 28/5/2019 | $ 2,94 |
28/3/2018 | 28/8/2019 | $ 2,94 |
28/3/2018 | 28/11/2019 | $ 2,94 |
28/3/2018 | 27/2/2020 | $ 2,94 |
28/3/2018 | 27/5/2020 | $ 2,94 |
28/3/2018 | 27/8/2020 | $ 2,94 |
28/3/2018 | 30/11/2020 | $ 2,94 |
28/3/2018 | 25/2/2021 | $ 2,94 |
28/3/2018 | 26/5/2021 | $ 2,94 |
28/3/2018 | 26/8/2021 | $ 2,94 |
28/3/2018 | 29/11/2021 | $ 2,94 |
28/3/2018 | 23/2/2022 | $ 2,96 |
28/3/2018 | 20/1/2020 | $ 3,05 |
28/3/2018 | 16/4/2018 | $ 4,00 |
28/3/2018 | 23/5/2018 | $ 5,00 |
28/3/2018 | 25/6/2018 | $ 5,00 |
28/3/2018 | 25/7/2018 | $ 5,00 |
28/3/2018 | 26/10/2018 | $ 5,00 |
28/3/2018 | 19/7/2018 | $ 5,50 |
28/3/2018 | 17/8/2018 | $ 7,80 |
28/3/2018 | 11/5/2018 | $ 9,93 |
28/3/2018 | 23/4/2018 | $ 10,00 |
28/3/2018 | 4/6/2018 | $ 12,00 |
28/3/2018 | 27/4/2018 | $ 18,00 |
28/3/2018 | 5/9/2018 | $ 20,00 |
];
Concatenate(Table1)
Table2:
Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total
inline [
Date | Expiration_Date_2 | Total_2 |
---|---|---|
28/3/2018 | 3/4/2018 | $ 8,56 |
28/3/2018 | 4/4/2018 | $ 9,06 |
28/3/2018 | 11/5/2018 | $ 9,93 |
];
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