Getting row number using dynamic way

Help Studio
, ,
1

Hello Team,
Please help me in getting row number using assign activity without for each row.
I have a table (extracted using activity “Extract Data Table”).
In that data table we want to check (Number of Rows )in which row with column 0 is having value “Lab” (given static value). so that we can remove top given row .

2

Hi @Aditi0374

RowIndex = (From row In dt.AsEnumerable()
 Where row(0).ToString = "Lab"
 Select dt.Rows.IndexOf(row)).FirstOrDefault()

Regards,

3

Assign Activity
idxRow | DataType: Int32 =

YourDataTableVar.ToList().FindIndex(Function (x) x(0).toString.Trim.ToUpper.Equals("LAB"))

it will return the 0based found row index (first occurence) OR
-1 when not found

4

If Activity | Condition: idxRow > -1

  • Then: Assign Activity: dtCleansed =
    YourDataTableVar.AsEnumerable.Skip(idxRow).CopyToDataTable
5

@Aditi0374

In addition to above we can also achieve this by using Remove Data Row actiivty

The image depicts a workflow sequence in UiPath which reads data from an Excel file's "Sheet1," determines a row index, displays it in a message box, checks if the index is greater than zero, and if so, removes the corresponding data row from a data table named "DT." (Captioned by AI)
The image depicts a workflow sequence in UiPath which reads data from an Excel file's "Sheet1," determines a row index, displays it in a message box, checks if the index is greater than zero, and if so, removes the corresponding data row from a data table named "DT." (Captioned by AI)818×1044 46.1 KB

Regards,

6

what is the value in assign activity “rowIndex”

7

@Aditi0374

(From row In dt.AsEnumerable()
 Where row(0).ToString = "Lab"
 Select dt.Rows.IndexOf(row)).FirstOrDefault()