Query related Lookup data

[Jeeru_venkat_Rao]

Hello Friends,

I pull data from SQL and the website, and I need to compare the website data to the SQL data to see if anything is missing. We only need to retrieve the number id from the website data. Find the attachment in the screenshot. Please create xaml for this if at all possible.

I want desire output. We can modified column headers for run the bot.

Vlookup data.xlsx (8.3 KB)

[adiijaiin (Aditya Jain)]

hi @Jeeru_venkat_Rao

You can use the following workflow,

I have used WebData.xlsx as your WebSite Data, Vlookup data.xlsx as your SQL data source
Have compared them and updated in the excel.

WebData.xlsx (8.7 KB)
consolidatedMatches.xlsx (8.4 KB)
ExcelMatching.xaml (16.6 KB)
Vlookup data.xlsx (8.3 KB)

Thanks

Happy Automation