Forum Discussion

luojiandan_bi's avatar
5 years ago
Solved

Power 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.

3 Replies