So my dilemma is as follows:
- I have an Excel Sheet with each column having a different date.
- The idea is to check a PDF file’s date and see if it matches the date on the Excel Sheet.
- If it does, populate the table with data from that particular PDF file.
- If it does not, go to the next one until the right date is found.
So far I have tried to to do:
For each Row --> For each col in dt(columns), but that does not seem to be working out that well.