Re: Combining Multiple Fields - Qlik Community

microwin88x · ‎2018-08-09

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!!!

manas_bn · ‎2018-08-09

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;

Anonymous · ‎2018-08-10

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:-

arvind1494 · ‎2018-08-10

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

];

manoj217 · ‎2018-08-10

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