How to compare Excel Header values with DB column data

sairam.vasanthakumar · October 21, 2022, 9:37am

Hi,

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

anshu.khetarpal · November 28, 2022, 4:53am

Hi,

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

sairam.vasanthakumar · November 29, 2022, 7:54am

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.