Which activity to be used in 3rd point and how to compare it common folder

  1. Open INVOICE folder on computer (Folder path to be finalized) – need to create folder
  2. Open LOG File spreadsheet – read file using read range activity
  3. Pick the first entry from LOG file where ‘Completed’ column-C value is not ‘X’ and Obtain the PAYROLL DATE (Column-A master job ) and Invoice Date (Column-B sales journal)
  4. Open MasterJobCost spreadsheet for the respective payroll date
    image

calculate the index of first found row where c-col is not X

myIndex = dtDataVar.AsEnumerable.toList.FindIndex(Function (x) Not x(ColNameOrIndex).toString.Trim.toUpper.Equals("X"))

then access the row by

dtDataVar.Rows(myIndex)(ColNameOrIndex).toString

In which activity should be used