topic Re: Strange Join considering Occurrence in App Development

Strange Join considering Occurrence

micheledenardi — Fri, 24 Aug 2018 09:45:02 GMT

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

Have these two tables:

Tab1:

Qty (Key)
20
20
10
30
10
30

Tab2:

Delivery	Qty (Key)
1	30
2	10
3	10
4	20
5	30
6	20

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:

In order to obtain this result:

FinalTable:

Qty	Delivery
20	4
20	6
10	2
30	1
10	3
30	5

How to do this ?

Re: Strange Join considering Occurrence

dsharmaqv — Fri, 24 Aug 2018 10:08:23 GMT

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.

Re: Strange Join considering Occurrence

puttemans — Fri, 24 Aug 2018 10:12:36 GMT

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, ....