Need help to implement following logic in qlikview.
A
B
Source
Source
New
Steps
P07
TS BD
P08
Pro001
1
Check if it’s in P07
No
2
Check what is the ID row for this Proforma in TS BD
ID1234
3
Check if this ID row is there in P07
4
If yes don’t include the Proforma in P08
5
If no include in P08 new accrual file
Explanation:-
I have two excel file as shown above (P07, TS_BD) and one qlikview report (P08) in tabular format.
I need to compare proformaparent column value of P08 file with the proformaparent column value of P07 , if it's not same then I need to check what is the IDrow(Another column) for that proforma in TS_BD excel file.
if that particular ID row(From TS_BD excel file) is there in P07 then no need to include in qlikview report, otherwise include.
please let me know if its possible to implement in qlikview ??
