How I can erase a column from the data base?

Tdragi13

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 ?

ceaperez

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

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.

rjones13

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