Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

Try like below

Temp1 :

Load

Warehouse

[Test.xlsx]

(ooxml, embedded labels, table is S1);

Join

LOAD Id,

Date

FROM

[Test.xlsx]

(ooxml, embedded labels, table is S2);

MyData:

LOAD Id,

Warehouse,

Date,

Sales

FROM

[Test.xlsx]

(ooxml, embedded labels, table is S1);

Outer Join (MyData)

Load * Resident Temp1;

Drop table Temp1;

Anonymous
Not applicable
Author

thanks.

if i change some value in Warehouse field (in second row Man->Main1), i get strange result:

   

IdWarehouseDateSales
1Main01-01-201634
1Main02-01-2016
1Main03-01-2016
1Main06-01-20162
1Main07-01-20165
1Main10-01-2016
1Main101-01-2016
1Main102-01-2016
1Main103-01-2016
1Main104-01-20167
1Main110-01-2016
perumal_41
Partner - Specialist II
Partner - Specialist II

always you want  Warehouse as Main. please let me know  if more then one warehouse is there m then how how is your output need

Anonymous
Not applicable
Author

First table:

    

IdWarehouseDateSales
1101.01.201634
1204.01.20167
1306.01.20162
1407.01.20165

Second:

  

IdDate
101.01.2016
102.01.2016
103.01.2016
110.01.2016

Result:

    

IdWarehouseDateSales
1101.01.201634
1102.01.2016
1103.01.2016
1110.01.2016
1204.01.20167
1202.01.2016
1203.01.2016
1210.01.2016
1306.01.20162
1302.01.2016
1303.01.2016
1310.01.2016
1407.01.20165
1402.01.2016
1403.01.2016
1410.01.2016
perumal_41
Partner - Specialist II
Partner - Specialist II

same output above script . any have attaching sample for your reference

Anonymous
Not applicable
Author

many thanks for help!

and i have one more problem to finish my task...

in first and second source i add one more field Nomenclature Id.

I the same way i need to add dates and nomenclature id from S2.

Please, help..

Test examples in attachment:

necessary result:

    

IdWarehouseDateNomenclature IdSales
1101.01.2016a34
1101.01.2016b
1102.01.2016b
1103.01.2016c
1110.01.2016a
1204.01.2016a7
1201.01.2016b
1202.01.2016b
1203.01.2016c
1210.01.2016a
1306.01.2016b2
1301.01.2016b
1302.01.2016b
1303.01.2016c
1310.01.2016a
1407.01.2016d5
1401.01.2016b
1402.01.2016b
1403.01.2016c
1410.01.2016a
perumal_41
Partner - Specialist II
Partner - Specialist II

please upload sample data

Kushal_Chawda

andreyfcdk91

People are here to help you, but that doesn't mean that every time you add the one field and show the results are incorrect. Instead request you to share a sample excel which consist of all the required field and also show the expected output for the same, so that it will be easy to find the solution.

QlikCommunity Tip: How to get answers to your post?

Anonymous
Not applicable
Author

in attachment..

Anonymous
Not applicable
Author

If i have more time to find solution by myself, of course, i have do it..

But this source has some people, who have ability help me operatively..

If you do not like the method of contacting my post, sorry...