, I'm working on a simple shiny app and I'm trying to create a drop-down list using one of the columns "Department" (which is a character atomic vector) in the excel data which I imported into RStudio, the code I'm using is as follows:
selectInput("select", "Select Department/Entity",
choices = unique(Key_Risks["Department"]))
when I run the app, nothing appears in the drop-down list, the only thing that appears is "NA", not the department names!
Your support would be highly appreciated. Thanks,