variable column name
2 Topics
Changeing the variable/column names in dataset broke all my reports
Hi Community, So we decided to get a correct common nameing convention on all of our datasets that are referring to the same columns in our database. So we removed all the spaces from names of columns inside our dimensions/fact-tables e.g. inside the dimension dim_ContractingParty we changed "Contracting Party Description" into "ContractingPartyDescription" and everything seemed fine in the datasets. They are still referring to the same naming in our database we only changed the naming in the datasets. And since everything seemed to be working we published them to our workspace and all the reports created from these datasets broke. Is there a quick fix for this? Or do we have to recreate all reports (hundreds) or rollback the name changes of the variables/columns? Thank you very much in advance, ApatSolved2KViews0likes1Comment
R table - dynamic column name
Hello, I need a table visual in R for wich the name of a specific colum must get a value from a measure. I'm new to R but until now I could manage to rename a colum and obtain a new name using this code: library(gridExtra) colnames(dataset)[colnames(dataset)=="TotalBase"] <- "NewName" So the original name "TotalBase" was transformed into the "NewName". But how could I pass a measure value? Is it possible to achieve something like this?: colnames(dataset)[colnames(dataset)=="TotalBase"] <- Table[Measure] Kind Regards, LucianSolved