Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Joining dates

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:

   

IdDateSales
101.01.201634
104.01.20167
106.01.20162
107.01.20165

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

My necessary result table:

   

IdDateSales
101.01.201634
102.01.2016-
103.01.2016-
104.01.20167
106.01.20162
107.01.20165
110.01.2016-

Help, please!

26 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

please check attached application

Anonymous
Not applicable
Author

Thanks..

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

IdWarehouseDateNomenclature IdSales
1101.01.2016a34
1101.01.2016b
1102.01.2016b
1103.01.2016c
1110.01.2016a

After your script:

    

IdWarehouseDateNomenclature IdSales
1101-01-2016b34
1102-01-2016b
1103-01-2016c
1110-01-2016a

Nomenclature Id b replace with a..

perumal_41
Partner - Specialist II
Partner - Specialist II

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
Not applicable
Author

Thanks so much!!!!!

Anonymous
Not applicable
Author

Could you please open inbox messages for me?

perumal_41
Partner - Specialist II
Partner - Specialist II

sure . inbox means Email  or Qlikview Personal message?,

Anonymous
Not applicable
Author

Qlikview Personal message