Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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