Hi guys,
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??
Regards,
Nirmalya
You can use Lookup Data Table
Here is workflow
Sequence.xaml (6.6 KB)
Hope it will work
Regards
Gokul
Hey @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. @nirmalya.sarkar
So it will help for others user
Regards
Gokul
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123