SQL Server Load percentage value along with percentile from excel file to SQL table using ADF

wwwo4jvm 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(90)

I have few percentage values in a Excel file. Now I want to load the data into a SQL table using Azure Data factory copy activity, While loading the data into a SQL table from Excel file the percentage values are converting into a decimal value during data load.

I have modified the datatype of a column which holds percentage value as varchar, Still it is loading percentage values as decimal values into the percentage columns.

What's the approach should I follow to load percentage values directly in the format of percentage into the SQL table?

I have modified the datatype of a column which holds percentage value as varchar, Still it is loading percentage values as decimal values into the percentage columns.

sql-server

来源：https://stackoverflow.com/questions/77170251/load-percentage-value-along-with-percentile-from-excel-file-to-sql-table-using-a

1条答案

按热度按时间

of1yzvn41#

If the type of the column is of Percentage in source excel, then the data will be read as decimal only in ADF. You can correct this either in source excel or after copying the data to SQL table using sql script.

You can use the Script activity, next to copy activity and give the query as,

update <table_name>
set
<column_name>=<column_name>*100

赞(0）回复(0）举报 2023-10-15

我来回答

SQL Server Load percentage value along with percentile from excel file to SQL table using ADF

1条答案

相关问题

热门标签

最新问答