Joining dates

[Anonymous]

Good day!

Colleagues, i have some simple model to understand how to join (fill) values by some key field.

I load main table from sheet S1:

Id	Date	Sales
1	01.01.2016	34
1	04.01.2016	7
1	06.01.2016	2
1	07.01.2016	5

then i need to join to this table all dates by Id field from sheet S2.

My necessary result table:

Id	Date	Sales
1	01.01.2016	34
1	02.01.2016	-
1	03.01.2016	-
1	04.01.2016	7
1	06.01.2016	2
1	07.01.2016	5
1	10.01.2016	-

Help, please!

[perumal_41]

please check attached application

[Anonymous]

Thanks..

For example, see Id 1 Warehouse 1. After joining Dates and Nomenclature_Id from S2 result must be:

Id	Warehouse	Date	Nomenclature Id	Sales
1	1	01.01.2016	a	34
1	1	01.01.2016	b
1	1	02.01.2016	b
1	1	03.01.2016	c
1	1	10.01.2016	a

After your script:

Id	Warehouse	Date	Nomenclature Id	Sales
1	1	01-01-2016	b	34
1	1	02-01-2016	b
1	1	03-01-2016	c
1	1	10-01-2016	a

Nomenclature Id b replace with a..

[perumal_41 · Accepted solution]

I did small mistake and  change the below script

like

Temp1:

LOAD
Warehouse//,
   //[Nomenclature Id]
FROM
C:\Users\perumal_ayyappan\Desktop\Test.xlsx
(ooxml, embedded labels, table is S1);

Join


LOAD Id,

Date,
[Nomeclature Id] as [Nomenclature Id]

FROM



(ooxml, embedded labels, table is S2);



MyData:

LOAD Id,

Warehouse,

Date,

Sales,
[Nomenclature Id]

FROM



(ooxml, embedded labels, table is S1);





Outer Join (MyData)





Load * Resident Temp1;



Drop table Temp1;

[Anonymous]

Thanks so much!!!!!

[Anonymous]

Could you please open inbox messages for me?

[perumal_41]

sure . inbox means Email  or Qlikview Personal message?,

[Anonymous]

Qlikview Personal message