How I can erase a column from the data base?

Tdragi13
Tdragi13 New Altair Community Member
edited November 5 in Community Q&A
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 ?

Best Answer

  • Caperez
    Caperez Altair Community Member
    Answer ✓
    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

Answers

  • Caperez
    Caperez Altair Community Member
    Answer ✓
    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
    hdava030 New Altair Community Member

    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
    RolandJones
    Altair Employee

    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