Eliminate the columns that are automatically created when using R to output data.

[Lopez0090]

I am running the following R script in Power BI Desktop (Query Editor).

However, there are blank column names (indexes?) in the output data. are automatically created in the output data.

Is there a way to prevent this column from being created,

or is it possible to output the column name as something arbitrary instead of blank?

currentDate <- Sys.Date()
output <- as.data.frame(dataset)
FileName <- paste("C://test/test", currentDate, ".csv")
write.csv(dataset, file = FileName)

 

If anyone knows a good way to do this, could you please let me know?

Best regards, Lopez

[Lopez0090]

@amitchandak 

Thank you for your answer.

I apologize for my lack of explanation. The "columns with blank names" are not displayed in Power Query.

What is causing the problem is that when I run the R script and output to a csv file, it adds "columns with blank column names".

So I'm thinking it's caused by the R script, do you know what it is?

Best regards

[amitchandak · Accepted solution]

@Lopez0090 , In power query, select the columns you want and use option remove others, this make sure any additional column will get deleted