Azure SQL Database
An Azure relational database service.
Empty columns in Source excel file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Arshad Kotwal
0
Reputation points
Hi Team,
As my source location is ADLS and Source file is Excel, with the Empty columns in the excel sheet my get Metadata activity gone failed. is there any solution approach to exclude Empty columns.
Note : I am using this Get Metadata activity to get the structure of the Excel file.
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
{count} votes
-
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator2024-01-19T12:24:29.7333333+00:00 Can you plz share the screenshot of your sample excel file and explain based on that file what your expectation is? That would help us get a clear picture of your ask
Sign in to comment
Sign in to answer