Uipath database query issue

Help StudioX
,
1

Hi I am getting a webscarpped data from a website it is called databale as web_Data

and other side we have a datable in sql database as Db_Data

now from this based on web_Data we have a column value and that if it matches on Db_Data with the same column.

–>if column value matches we need update a another column called Date

Input: Web_Data

Name Speciality Contact Date
karthik Doctor 9999
Harika Dentist 9999

Db_Data

Name Speciality Contact Date
harish Doctor 9999
Hartha Dentist 9999

Output:

Name Speciality Contact Date
harish Doctor 9999
Hartha Dentist 9999
2

This is called a join, it’s a standard database function. Use the Join Data Table activity.