Carrie Glaser 2 Posted April 16, 2020 Share Posted April 16, 2020 I have a column with 20 catories in the excel source file, but in Spotfire, there are 23 categories and three of them are duplicates. Does anyone know why this has happened and how to undo it Nevermind I figured it out. There was a space at the beginning of the text in some cases but not others; excel doesn't care about this when it shows you the values in a filtering menu, but Spotfire does. Link to comment Share on other sites More sharing options...
Karan Nisar Posted April 16, 2020 Share Posted April 16, 2020 Additionally while importing the excel file into Spotfire, you can check the number of categories in the import settings wizard and accordingly uncheck the categories too. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now