Stuart Wise Posted February 1, 2019 Share Posted February 1, 2019 Hi All, I have a table that has columns for every hour of the day (00:00-01:00, 01:00-02:00 etc etc) I also have a list of names and based on what they did on that hour I have a value set 01:00-02:00 02:00-03:00 Stuart Did Something Basically I want some script that goes through the entire table of marked data and when it finds an empty value it removes the entire column. I've tried a number of different ways but I cant get it to pick out the specific columns. Any help with this would be greatly appreciated. Kind Regards, Stuart Link to comment Share on other sites More sharing options...
Sayali Patil Posted February 8, 2019 Share Posted February 8, 2019 Hello, Not sure how your data set looks like but here are some pointers. You can loop through the required column using python for the marked rows - https://community.spotfire.com/wiki/how-retrieve-data-marking-selection-usi... To remove columns from the data table - https://community.spotfire.com/questions/how-delete-columns-effciently-spot... 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