Hi, I am using REFramework. The workflow reads rows one by one from an Excel sheet using Read Row based on the transaction number. However when there is a blank row I want it to return Nothing to stop the workflow.
How do I check this condition - to check if the row is blank or no data returned?
Kindly refer the below link:
Use below code to remove empty row from the table.
Use assign activity
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()
Re-usable Component pass Parameter as datatable you will get the answer.
RemoveEmptyRows.xaml (8.5 KB)
Remove rows based on particular column is empty.
DataTableName.Select("Convert(column3, System.String)< >''"…
Hi, I am using REFramework and reading data rows one by one. Not using DataTable, only DataRows. So I can only detect an empty row after the transaction counter increments and shifts down. How do I do this?
Maybe you can use If statement like this :
IF DataRow(“ColumnName”).ToString <> Nothing then
And then do your logic
Apply this before moving to Transaction process, so you will have values for all the rows.
Hi, the reason for not using DataTables is because for some previous versions of UiPath the workflow will hang due to RAM restrictions when processing large volume data
How do I do this in bulk to check if the entire row is empty? Preferably without looping
Check this thread, it helped me
Hi everyone, I am still very new to UiStudio. I have an issue of checking whether the dataRow is empty. I would like to check if it’s null. I read through all of the other issues but none of them seem to be working for me…
It’s an if condition to check if the dataRow variable is null.
I don’t really understand this thread, is it asking about processing a DataTable as an array of DataRows?
What I would like to find out is
I am using Read Data Row. This returns an iEnumerable
Check within this iEnumerable for whether Read Data Row has scanned an empty row
Try this: in IF condition:
Not row.ItemArray.All(Function(field) field Is DBNull.Value or field.Equals(“”))