Excel reading issues

Hii everyone,
Flow of Workflow
Extract table from web page
Using For each Row
Detecting a value from the column A
Relating to the column A, the value corresponding to it that is if it is Column C then the Value from Column C is to be picked up.

Thanks and Regards,
Supriya

what exactly are you looking for?

In the for each row activity insert an IF activity with the following condition

IF

row.item(“ColumnA”).tostring = row.item(“ColumnC”).tostring

THEN

Assign VAR = row.item(“ColumnC”).tostring

ELSE

[Blank]

1 Like

@supu123 follow the below syntax

resuletdDT=YourDT.Select(“ColumnB=ColumnC”).CopyToDataTable

Regards,
Mahaling Patil

1 Like

Hiii…


I want to check whether the Party column contains “The Financial” is yes then store the “case number” related to it in a variable

is the content after extract datatable in uipath

Mainly, The above image shows the column-1,column-2,… at the top
What are the steps and code to run the above process
please specify the expression related to it.

Thanks and Regards,
Supriya

Read the Collum and put it into a variable of strings. Then create a for each item of the colllum.
In this for each you make a if statement if the item.ToString.Contains(“THE VALUE YOU WANT”) Then write it away or save the First collum number.

As stated above, use a For Each loop on the datatable. Then an IF activity acting on each row to check if the word “Financial” appears:

The assign syntax is “row.Item(“Column-1”).ToString”

You can then use the Case Number as you wish, maybe saving to another datatable.