Hi all.
Hope someone could direct me in the right direction on solving my problem.
I need to flag records in a table on matching criteria. I think the best way is going to have to use the peek() function.
I have a few dimension containing transaction data. I need to check for matching doc numbers and where they are found check the customer linked to the document.
example of data:
| DATE | DOC_NO | CUSTOMER | #FLAG |
|---|
| 2018-01-01 | 123 | A | OK |
| 2018-01-01 | 123 | A |
| 2018-01-01 | 124 | B | FAIL |
| 2018-01-01 | 124 | C |
if the document numbers match and the customer is a match for that document number it should be flagged as "OK", but where
the document numbers match and the customer differs it needs to be flagged as "FAIL"
I can find the matching DOC_NO, but i have no idea how to check the CUSTOMER when it is found, any ideas??
Thank you in advance....
