How to compare Excel Header values with DB column data


I’ve a use case regarding the comparison of excel headers with the SQL DB table column data. In this scenario SQL data is having both direct header and alias name also. So, need to check the excel header values is available either in direct header and alias name or not.

Kindly suggest a solution for this


Can you please share a snapshot of how the Excel (headers)and SQL table (headers) looks like?

Hi @anshu.khetarpal

The concept is to check whether the Excel header names is available in the DB table direct/Alias column values like a validation.

Note: Excel Headers will not be at the first row of the sheet.