match pattern join

[amiroh81]

Hi,

I want to join between two queries when the connection between them will be in the style of match pattern.

For example :

type	count
12333113	50
425723	5
124444	4444
8752211	32

group type	group number
1	AAA
42	BBB
1244	CCC
8752	DDD

type	count	group number
12333113	50	AAA
425723	5	BBB
124444	4444	CCC
8752211	32	DDD

Lines 1 and 3 have the same 2-digit prefix.

What I would like to see is that the first line will be connected with the first row and the third line will be combined with the third line only.

This means that no connection will be made between the third line and the first row 124444 <> 1 , 124444=1244

I hope I've been able to explain the problem

thanks in advanced

[MarcoWedel]

Hi,

one solution could be:

Edit: Removed solution and waiting for you to first close your open threads that received correct answers: amiroh81

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco