Bot reading blank row, how to avoid it

[Manju_Reddy_Kanughula]

I am using two excel to write the values into one excel. so in this process bot reading blank row also…

[Gokul001 (Gokul Balaji)]

Hi @Manju_Reddy_Kanughula

You can try with this expression

Not String.IsNullOrEmpty(Currentrow(“YourColumnname”).tostring)

Then → You can go ahead with the process

Else → You can iterate the next transaction

Regards
Gokul

[Manju_Reddy_Kanughula]

I am not getting where should i write the given code.

[Gokul001 (Gokul Balaji)]

Hi @Manju_Reddy_Kanughula

Use Another If activity above your if activity

Some thing like this check out the image

Regards
Gokul

[Manju_Reddy_Kanughula]

[pankajmohan.dhane (AKA PK)]

Hi @Manju_Reddy_Kanughula

Try to use filter activity and assign column name=empty (and select remove option )

It will remove all empty rows.

Thanks

[Gokul001 (Gokul Balaji)]

Remove the >0 in the expression @Manju_Reddy_Kanughula

[Manju_Reddy_Kanughula]

OT Excel having SH1339 is the last row… Output Excel have SH1344 is last but there is one more row for total…

[Gokul001 (Gokul Balaji)]

@Gokul001

Remove the >0 in the expression @Manju_Reddy_Kanughula

Have you Tried like this? @Manju_Reddy_Kanughula