Hi,
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 ??