Hi Qlikviewer,
I'm dealing with following issue, in the last days (and weekend ).
I have two tables they are linked on a general layer (ID). But they have detail information's they have to be linked (SequenceID).
- Table.A:
ID | A.SequenceID | Quantity |
1000 | 1000.1 | 100 |
2000 | 2000.1 | 100 |
2000 | 2000.2 | 100 |
2000 | 2000.3 | 100 |
2000 | 2000.4 | 100 |
3000 | 3000.1 | 100 |
…
- Table.B:
ID | B.SequenceID | B.Quantity |
1000 | 1000.A | 50 |
1000 | 1000.B | 50 |
2000 | 2000.A | 30 |
2000 | 2000.B | 70 |
2000 | 2000.C | 80 |
2000 | 2000.D | 50 |
3000 | 3000.A | 100 |
…
>> Result Table
B.SequenceID | A.SequenceID |
---|
1000.A | 1000.1 |
1000.B | 1000.1 |
2000.A | 2000.1 |
2000.B | 2000.1 |
2000.C | 2000.2 |
2000.D | 2000.2 |
3000.A | 3000.1 |
…
Drop Field ID
...
I have to link them in the way:
If ID(A)=ID(B) and A.Quantity (for each A.SequenceID) is not reached by B.Quantity then link A.SequenceID to B.SequenceID. (see result table)
I tried to load A and B concatenate with formula but I didn't managed it. I tried to handel it with "for each" A.SequenceID, A.Quantity but then I would need a command like this
If not Exists(Used.BSequenceID,'$(vB.SequenceID)') then ….
and this doesn't work. I assume that the "not Exists()" function just work with a where.
Does somebody have an idea to solve this issue are where I mistaken?
Thanks in advanced.
Best regards
John D.