Forum Discussion
luojiandan_bi
Helper I
5 years agoPower Query table to SQL Server by R script,why is that.0 extra
In Power Query Editor, the text string is: 123547126811
Why is the text string in SQL Server: 123547126811.0?
R Script:
library(RODBC)
conn <- odbcDriverConnect("driver={SQL Server}; server=localhost;Database=**;uid=uid;pwd=password")
odbcClearError(conn)
sql="Delete T From
(Select Row_Number() Over(Partition By cust_id order By cust_id) As RowNumber,* From tmp)T
Where T.RowNumber > 1"
sqlSave(conn, dataset, tablename="tmp",rownames=FALSE, safer=FALSE, append=TRUE,fast=TRUE)
sqlQuery(conn,sql) #delete duplicate data.
close(conn)
because The PowerQuery M code run twice,so run delete duplicate sql in R Script.
using format function is ok:
dataset$cust_id <- format(dataset$cust_id)
3 Replies
- luojiandan_bi
Helper I
wait for helping online.
- v-kelly-msft
Community Support
Hi luojiandan_bi ,
Check whether the data type has been changed automatically in power query,if so,close it.
Check the reference below:
https://a4accounting.com.au/stop-power-query-from-automatically-setting-data-types/
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- luojiandan_bi
Helper I
using format function is ok:
dataset$cust_id <- format(dataset$cust_id)