I am using two excel to write the values into one excel. so in this process bot reading blank row also…
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
I am not getting where should i write the given code.
Use Another If activity above your if activity
Some thing like this check out the image
Regards
Gokul
Try to use filter activity and assign column name=empty (and select remove option )
It will remove all empty rows.
Thanks
OT Excel having SH1339 is the last row… Output Excel have SH1344 is last but there is one more row for total…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.