I need to match two files based on a key, say key1. I am able to match them, say read file1 output dt1. Then in a loop, I read file2 output dt2. For every row in dt2, I find a corresponding row in file 1 (dt1) and append column status = ‘1’ in file2. So far so good.
The challenge is, I am not able to append another column, say ‘found’, when I need to indicate if the corresponding row in dt1 meets the condition of dt1.columnD > 0.
That is, I want to add an indicator in file2 to track if a certain column in file1 satisfies a certain condition.
Can somebody advise me. Thanks !