Hello all, I am attempting to run compares on massive CSV files with 300+ columns. An example I am trying to do below.
I'm wanting to first identify The source and ID. Both ID's need to match when comparing OW/OW1 Rows of data, then determine if the OW1 row is blank on Originator, Destination, Street and Zip, if the OW1 ID has all four of those fields blank and it matches the corresponding ID, create a reason code as "acceptable" in a new "Reason Code" Column being put on both the OW and OW1 row. Any direction on this would be helpful, I've been trying to piece this together with other posts but can't get it to work as expected.
