Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How I can erase a column from the data base?

If my data base has a column with a missing value. And I want to delete this column or hide it. How can I erase that and then when I press de play button show me the result with out this column ?

Find more posts tagged with

AI Studio

Databases

Filtering

Accepted answers

Caperez

Hi @Tdragi13

You can use the Select Attributes operator, select a single attribute type and choose the Attribute (colum) that you want to delete and mark the invert selection.

also you can use the Turbo Prep module for that. Or if you are importing data from a file or other sources, you can exclude the Attibutes (Columns) that you want to exclude before to import it using the Import Data Function.

Regards

All comments

Caperez

Hi @Tdragi13

You can use the Select Attributes operator, select a single attribute type and choose the Attribute (colum) that you want to delete and mark the invert selection.

Regards

hdava030

Hi,

please have a look at the operator you are introducing. It is not like that anymore.

I do not know which kind of industries use this software.

I used the detect outlier operator. then one column (outlier) was added to my dataset. filtered the outlier and then used the select operator to exclude the added column. whatever I do, it remains in my column.

RolandJones

Hi @hdava030 ,

In future please start a separate thread, just so discussions can remain focused 😊 Your outlier column has a special role called "Outlier", which you can tell as it's a different colour. If you tick the "also apply to special attributes (id, label..)" tick box for the Select Attributes operator, you will then be able to remove the column using that operator.

Best,

Roland