topic Re: Concatenate two tables with differentiate the date range in QlikView

Concatenate two tables with differentiate the date range

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How to Concatenate two tables with differentiate the date range.?

Concatenate 2014 SalesDate with those having 2015 WarrantyDate

Sales Date = 2014 with >=2015 Warranty Date

Warranty Date >= 2015 with 2014 Sales Date

Table1:

ID	Product	Sales Date
1	A	2014
2	B	2013
3	C	2015
4	D	2014
5	E	2012
6	F	2015
7	G	2017
8	H	2015
9	I	2013

Table2:

ID	Product	Warranty Date
1	A	2014
2	B	2014
3	C	2015
4	D	2016
5	E	2014
6	F	2015
7	G	2017
8	H	2016
9	I	2015

Re: Concatenate two tables with differentiate the date range

sunny_talwar — Thu, 09 Mar 2017 19:17:45 GMT

Do you want to concatenate or Join? Would you be able to provide desired output from the sample you provided?

Re: Concatenate two tables with differentiate the date range

Anonymous — Fri, 10 Mar 2017 06:32:13 GMT

(SalesDate=2014 and WarrantyDate>=2015)

ID	Product	Sales Date	Warranty Date
4	D	2014	2016

Sales Date = 2014 with >=2015 Warranty Date

Warranty Date >= 2015 with 2014 Sales Date

Re: Concatenate two tables with differentiate the date range

ahaahaaha — Fri, 10 Mar 2017 06:49:12 GMT

Hi Kirubakaran,

Maybe so?

Table1:

LOAD*Inline

[ID, Product, Sales Date

1, A, 2014

2, B, 2013

3, C, 2015

4, D, 2014

5, E, 2012

6, F, 2015

7, G, 2017

8, H, 2015

9, I, 2013];

Left Join

LOAD*Inline

[ID, Product, Warranty Date

1, A, 2014

2, B, 2014

3, C, 2015

4, D, 2016

5, E, 2014

6, F, 2015

7, G, 2017

8, H, 2016

9, I, 2015];

Perhaps there would be enough join only over field ID, if it is key.

Regards,

Andrey

Re: Concatenate two tables with differentiate the date range

settu_periasamy — Fri, 10 Mar 2017 06:50:57 GMT

May be like this..

T1:
LOAD * INLINE [
    ID, Product, Sales Date
    1, A, 2014
    2, B, 2013
    3, C, 2015
    4, D, 2014
    5, E, 2012
    6, F, 2015
    7, G, 2017
    8, H, 2015
    9, I, 2013
] ;


Left Join
LOAD * INLINE [
    ID, Product, Warranty Date
    1, A, 2014
    2, B, 2014
    3, C, 2015
    4, D, 2016
    5, E, 2014
    6, F, 2015
    7, G, 2017
    8, H, 2016
    9, I, 2015
];


NoConcatenate
T2:
LOAD * Resident T1 Where [Sales Date]=2014 and [Warranty Date]>=2015; 


DROP Table T1;

Re: Concatenate two tables with differentiate the date range

Anonymous — Fri, 10 Mar 2017 12:14:49 GMT

Hi,

Try this:

Table 1:

Load Autonumber(ID_Product) as Key,

ID as Table1ID,

Product as Table1Product,

[Sales Date]

Resident <Source>

Left Join (Table 1)

Load Autonumber(ID_Product) as Key,

ID as Table2ID,

Product as Table2Product,

[Warranty Date]

Resident <Source2>