Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to add an extra column in an existing table and I want that column to be filled with the following text "YTD".
output <- as.data.frame(dataset, stringsAsFactors = FALSE, row.names=NULL) output$F <- "YTD"
I get following error message:
DataSource.Error: ADO.NET: R script error. Error in read.table(file = file, header = header, sep = sep, quote = quote, : duplicate 'row.names' are not allowed Calls: read.csv -> read.table Execution halted Details: DataSourceKind=R DataSourcePath=R Message=R script error. Error in read.table(file = file, header = header, sep = sep, quote = quote, : duplicate 'row.names' are not allowed Calls: read.csv -> read.table Execution halted ErrorCode=-2147467259 ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException
Any help will be appreciated
Hi.
I have a similar problem. I want to add a new column in a table using Power Bi but I don't know how!
The script code is:
# new variable
dataset$new <- 0
f=nrow(dataset)
for (i in 2:f) {
if( dataset$num[i-1] == dataset$num[i] ) {
dataset$new[i-1] = dataset$start [i-1] - dataset$end[i] - 1
}
else { dataset$new[i-1] = "NO"
}
}
How can I insert this code?
Could help me, please?
Many thanks,
regards.
Hi @Anonymous ,
For the error "duplicate 'row.names' are not allowed ", you can refer to the similar cases:
https://stackoverflow.com/questions/8854046/duplicate-row-names-are-not-allowed-error ,
https://stackoverflow.com/questions/15285089/r-duplicate-row-names-are-not-allowed.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |