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


Was typing same :slight_smile:

Hi @ppr it’s quite difficult for me to comprehend what you are trying to do in assign activities could you maybe show in a workflow and also while using the read range activity to read each files can you also tell me how to only select 2 columns as my orignal files has other column values as well.

My actual file will have range from A-CV and i would want A and G columns only

find some visuals:



1 Like

Hi @ppr

In the merge Data Table activity when i enter the source value i get this error, could you help me here.


Looks Like an issue with the datatypes.
Can you Check if the typeargument for the for each Activity ist Set to datatable


Could you please share excel file

Hi @ppr
yeah it was object type, changed it to datatable works now.
My output still comes not the way i want it, there is a lot of spcae bw each record and i want it to be continuous without space,could you help me i am providing the as is and expected output.




Give a try on Filter Afterwards the result with Filter datatable Activity and remove the empty Lines by condition is not empty for both cols

1 Like

Hi @ppr

I tried this, it behaves very weirdly. For first 18 records it has removed the empty lines but then when i checked the entire excel sheet i found one record at 250th row and above it all were empty lines until 18th record.

keep in mind if in excel is within a cell a blank (space) it is rated as not empty. So an only visual check on an excel will not be sufficiently for analysing the data.

The filter datatable with the right filter configuration should remove those empty lines. Otherwise we can also use a LINQ statement for this

i am attachig a snip of my filter data table activity, can you let me know whether it is correct if yes, then how can i use LINQ statement for sorting this issue.


as it is unclear which column has some unneeded spaces within the empty rows so we would suggest to try it with an or conjunction instead of and

The issue still remains. I am getting something like below-

Continuous values until row 19th and then suddenly at 251st row i am getting one value

have a look here on starter help for getting rows where no col exists with an empty value:
GetRowsWithNoBlanksInAnyCol.xaml (7.9 KB)

well actually the data table you are using is a bit different than my scenario.
In the below case the missing values are random where in my case if a value exist in first column then there will be a corresponding value for it for sure( in this example there will be a value corresponding to B cause these values exist in pairs), Will it still work for my case, the workflow?


its a starter help. The main part for filtering is working with any datatable

Doesn’t help i still face the same issue.

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?