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