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

[Stuart Wise]

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

[Sayali Patil]

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...