Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

Strange Join considering Occurrence

Today i have to face a little bit strange situation...

Have these two tables:

Tab1:

Qty (Key)
20
20
10
30
10
30

Tab2:

DeliveryQty (Key)
130
210
310
420
530
620

Qty field is the key field between these tables.

I want to associate the first occurence of Tab2.Qty with the first occurence of Tab1.Qty, the second occurrence of Tab2.Qty with the second occurrence of Tab1.Qty... and so on, respecting the original sort order fo Tab2.

So the association would be:

2018-08-24 11_36_24-Immagine - Paint.png

In order to obtain this result:

FinalTable:

QtyDelivery
204
206
102
301
103
305

How to do this ?

2 Replies
dsharmaqv
Creator III
Creator III

Key column should not have duplicates. Try to identify any column, which help you to identify each row uniquely.

else try to generate your own unique key to perform join.

puttemans
Specialist
Specialist

I'm sorry, but isn't your FinalTable exactly the same as your Tab2 ?

If you need a more precise association because of other fields available, then you'd need to finetune your Key. e.g. concatenate with another variable that distinguishes between 2/10 and 3/10. Could be delivery address, delivery name, date&hour, ....