Using document property inside of aggregate function

[Spotfire Support 2]

I'm trying to use a document property to control whichcolumnfrom a data table is used as the first argument for the "aggregate" function, but am unsuccessful doing so. The script is workingfine when I use the actual column names, but when I attempt to use the document property as column name, the function returns "no rows to aggregate". Examples below.

 

Successful script: aggregate(Table$Column1, by = list(Table$Column2), FUN = median, na.rm = TRUE)

 

Unsuccessful script: aggregate(Table$DocProperty, by = list(Table$Column2), FUN = median, na.rm = TRUE)

DocProperty is a string and currently holds the value "Column1".

[Fabian Duerr]

Follow this approach using dplyr

library(dplyr)

testdf

[Spotfire Support 2]

Perfect, your suggestion to use dplyr with group_by and summarise worked perfectly. Thank you very much for the help!

[Fabian Duerr]

Thank you for the feedback!

 

If you want to learn more about data manipulation in R (with dplyr) I can highly recommend this book/ebook:

 

Data Manipulation in R by Stephanie Locke/ https://itsalocke.com/files/DataManipulationinR.pdf