Copy row range into next row in datatable

Learn Academy Feedback
,
1

Hi Everyone.

I have datatable as attached file ( The root file is very huge )

I want to check it row(0) is not empty then will copy range from A:F into the next below row.

How to do it.

Thanks in advance!

Book1.xlsx (8.3 KB)

Output
Output1291×568 29.6 KB

2

Hi,

Steps to achieve this:

1 - Read excel file
2 - Put filter on Data Table which is an output of Read Range Activity.
3 - Use normal filter activity in UiPath or use Assign Activity "dt.Select(“Item1”) <> “”)
4 - You can also use Linq in this case to get only those records which are not equal to empty
Follow this link -

1 Like
3

Hi Bro.

But my data sorted not easy.

Could you pls check and try to make xaml file.

Thanks in advance!

4

I have found solution from this link : Copy value from above row in excel - Help - UiPath Community Forum