Merging 3 excel files with non continuous records into 1 excel with continuous records

just do one thing:

  • divide and conquer

initial the task was about merging 3 excels into one

  • send 3 modified excels (control that there are no containing spaces etc.) into the merge and check the implementation

As a second step analyze the original excel data on why the passing the is non empty filter. Herefore we would recommend:

  • use the provided LINQ and check it while debugging and inspecting the data
  • analyz the data on blanks, line breaks etc.

For debugging we can recommend the debugging course offered on the UiPath Academy

Hi @ppr
Would it work if i remove trailing spaces form the 3 excel column and then merge them?