How to fetch alternate coloumn value depending on some hit on other coloumn value of the same excel?

How to fetch alternate coloumn value depending on some hit on other coloumn value of the same excel?

Use Case Description

HI All…In the attached excel sheet , i have a column at the end “Number of Dependents”, as soon as the counter strikes 0 value it should fetch the email address for that respective 0 value. Please provide solution.

AS-IS WORKFLOW, TO-BE WORKFLOW

Attended - Test Data Set 1 - New Accounts.xlsx

Other information about the use case

Industry categories for this use case: BFSI, Compliance, Customer Service, Finance, Healthcare Pharma, HR, Information Technology and Services, Legal, Logistic, Manufacturing, Marketing Sales, Operations, Telecom, Universities Academy, Other Sector

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio

Other applications that were used: -

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency

Hi @akshay_kalambe ,

Read your excel to datatable. Then do “for each row in Data Table” and open if condition and check

CInt(row(“Number of Dependents”).ToString) = 0

If it is true get row(“Email”).tostring

attached sample workflow for you
FetchAlternate.xaml (7.3 KB)

Thanks a lot buddy…it works!!!

1 Like

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