Select the element based on the excel value

Help Orchestrator
,
1

Sample Input Excel file

ProjectName Cost Technology Quality Delivery
Test Project 1 100 80 70 100
Test Project 2 70 100 70 100

Above excel data will be added to queue or we will read data directly from excel and our bot will search the each project in the portal .

if the value of the cost in the excel is 80 or below then it has to select the Cost in 1.2 deficiency element OR if the value is above 80 then bot has to select NA.

image
image813×461 62.3 KB

and repeat the steps for remaining deficiency elements as per the excel.

May I know the logic to complete this task?

2

@Sathish_Kumar_S

Use Read Range activity to Read the Excel and declare a variable in the properties to make data to Datatable, Let’s say the variable is Dt

Now use For Each Row activity and pass the variable which is Dt

Use IF condition inside For Each Row activity write condition as

Cint(row(“Cost”).ToString) > 80

Then-> Place Select Item activity, and write as “Cost”, If you are getting error then you have to keep click activity to click the dropdown and any click activity to click on Cost

Else->Place Select Item activity, and write as “NA”, If you are getting error then you have to keep click activity to click the dropdown and any click activity to click on NA

Repeat the same for others also, but it should be inside the For Each row

Hope this will help you

Thanks

3

Hi

This can be achieved with a if condition

Hope the below steps would help you resolve this

Let’s take you have the value in queue or excel and retrieved the COST column value alone in a string variable named Strinput

Now use a IF condition and mention the condition like this

Convert.ToInt32(Strinput.ToString.Trim) <= 80

If true it goes to THEN block then select that 1.2 deficiency element with a click activity and use select item to choose any value from drop down

Or goes to ELSE block where use select item to choose the NA value from you want

if select item does word use a normal click activity two times where first click on that drop down and second choose the value

Cheers @Sathish_Kumar_S

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.