Data Migriation in Excel Sheet including Vlookup

Help Studio
, ,
1

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
image411×520 7.31 KB

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

How to do it…

Thanks
Shyam

1 Like
2

Hey @Shyam_Pragash

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

Thanks
#nK

3

Hi @Nithinkrishna

Yes…

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

image
image987×489 14.8 KB

i have choose column Name to do above condition using vlookup

Thanks
Shyam

1 Like
4

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

5

Hi @Nithinkrishna

How to inter link with vlookup forumula in this activity…

Thanks
Shyam

1 Like
6

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
7

Hi @Nithinkrishna

ok … i will check …

Thanks
Shyam