in the below scenario where if any document has an reversal enrty, i have to show Yes in a column called Is Reversal and No if it do not contain a reversal entry.
DDOC (Document No)
RDOC (Reversal Doc)
Is reversal
123
456
Yes
456
123
Yes
789
No
987
No
I have used the below logic, but it is not showing Yes for all reversal entries. can you let me know where Am going wrong.
Map:
Mapping Load
RDOC,
DDOC
FROM
[Test.QVD]
(qvd);
and in main table
If(match(RDOC,Applymap('Map',DDOC)),'Yes','No') as Is reversal
is not working.
Basically, if RDOC is in DDOC i want it as Yes and no if it is not there.
