I’m loading excel data into a SQL table using Read Range activity.
Sometimes the spreadsheets headers are spelled differently or missing a character (example: Last_Name is entered Last Name)
Can someone help me adjust the header names properly with logic? I’m guessing that I could maintain a list of values inside a IF activity.
Any help would be greatly appreciated