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).
>> Result Table
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.