Excel backfilling automation - Lookup data table activity

Help Activities
, ,
1

Hi All

I have created an excel backfilling automation, which takes the data from one excel to another using Look up data table activity. But Unfortunately I’m getting this error & it suddenly stops at row 44.
image

Regards
Naman

2

Is row 44 blank? it looks like it cannot convert it as there is no value

3

workaround / fix:
cleansing up the lookup table by filtering out all rows where the relevant columns are null / empty

4

Hi @Naman_Arora ,

Could you try changing the Output variable type of Lookup Datatable activity to UiPath.Core.GenericValue and check ?

5

Hi

Yes I change it to UiPath.Core.GenericValue but I have just checked the input sheet has few blank values. So will it be any issue ?

Regards
Naman

6

Yes it has blank value. So What can I do in this case ?

7

you can use an If statement to check if the cell value is null to skip it, and if it is not to continue.

Or use a filter datatable to remove empty values

8

Hi @Naman_Arora - Use Filter DataTable activity to remove the empty rows first then perform the required operation. Check the below link on the same process

Link - https://www.youtube.com/watch?v=J0S-9KhEBRQ