Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

match pattern join

Hi,

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

For example :

typecount
1233311350
4257235
1244444444
8752211

32

group typegroup number
1AAA
42BBB
1244CCC
8752DDD

typecountgroup number
1233311350AAA
4257235BBB
1244444444CCC
875221132

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

1 Reply
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_299181_Pic1.JPG

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