I am working on ERP application. In this process i have stored a value in a variable by screen scraping.
Let, the stored value is = Virat.
What I have to do is compare this value(virat) with the excel column containing this value .
Demo-1.xlsx (8.6 KB)
If this two value matches I have to get the corresponding column value
From “Profession” column I have to get the value as “Cricketer”.
Can you please guide me??
t I have t
MatchValue.xaml (7.3 KB)
Here you go, you can reference the attached file.
You can use Lookup Data Table
Here is workflow
Sequence.xaml (6.6 KB)
Hope it will work
@nirmalya.sarkar! Let’s use the “Lookup DataTable” activity!
Step 1: Lets read your demo. I stored the read table in a dt variable “dt_test”
Step 2: I created an array with all the names of the table so that we could visualize a test in several cases.
Step 3: Let’s look at this array and use the “Look up DataTable” for each of the names.
Step 4: Let’s understand the properties of this activity.
→ Datatable is the table where we want to get our matches.
→ Lookup Column is the column where we want to look for the value we know, that is, in our case it is the name.
→ Target Column is the column where we want to find the value that we don’t know and want to find out, which in our case is Profession.
→ Output is the found value that we want to find out.
Step 5: We made a print to verify each correspondence.
Checking the result.
Hope this helps!
Adding the .xaml.
Main.xaml (9.3 KB)
If your query is resolved, Kindly mark the appropriate post as solved.
So it will help for others user
Forum FAQ - How to mark a post as a solution
This document is part of our beginners guide.
This article will teach you how to properly mark a post as a solution.
We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them.
When is the topic resolved?
The topic can be considered resolved when the topic author has fo…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.