Data Migriation in Excel Sheet including Vlookup

Hi…

i have excel file it contains 441 rows and 128 Columns in that excel… i am tring to vlookup to update the data… some time the data was not populated few cell…

In that below excel sheet…

image

if the cell is null or empty. It will popluate 0 …

How to do it…

Thanks
Shyam

1 Like

Hey @Shyam_Pragash

You want to do the current logic which you have in vlookup into uipath manipulation ?

Thanks
#nK

Hi @Nithinkrishna

Yes…

in that exel sheet some fields data are null or empty… that cell write 0 refeclted is empty…

i have choose column Name to do above condition using vlookup

Thanks
Shyam

1 Like

Hey @Shyam_Pragash

For-each row in (Table)

     For-each column in (Table.Columns)

            If(string.isNullOrEmpty(Convert.ToString(row(column)).Trim))

               Assign : row(column) = 0

Hope this helps

Thanks
#nK

Hi @Nithinkrishna

How to inter link with vlookup forumula in this activity…

Thanks
Shyam

1 Like

Hey @Shyam_Pragash

The above doesn’t involve any vlookup.

It’s just that the same logic is done with UiPath.

But still if you want to use vlookup only then you may need to perform with below activity,

Hope this helps

Thanks
#nK

1 Like

Hi @Nithinkrishna

ok … i will check …

Thanks
Shyam