Jump to content
We've recently updated our Privacy Statement, available here. ×

Using Ironpython to remove a series of columns from a Table based on Value


Stuart Wise

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...