"Retrieve from Database: is preprocessing data possible?"

Fred12
Fred12 New Altair Community Member
edited November 2024 in Community Q&A

hi,

when retrieving Data from a table from a database, I have to set the label class and data types manually every time ... is it somehow possible to set columns predefined as label class? and set datatypes before retrieving them from a database? e.g remove columns, set datatype or set label class, then save those settings for that database table, and keep the settings when retrieving the tables again...

otherwise doing this manually all the time is kind of tiring...

Best Answer

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓

    Hi!

     

    If you need to insert the same combination of operators over and over again, check out Building Blocks. You could set up your DB preprocessing once in a Subprocess operator and save that as a Building Block. Just like the predefined Building Blocks like X-Val, your own Building Block can contain any number of configured operators. This will save you a lot of time if you need it frequently.

     

    Cheers,

     

    Balázs

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓

    Hi!

     

    If you need to insert the same combination of operators over and over again, check out Building Blocks. You could set up your DB preprocessing once in a Subprocess operator and save that as a Building Block. Just like the predefined Building Blocks like X-Val, your own Building Block can contain any number of configured operators. This will save you a lot of time if you need it frequently.

     

    Cheers,

     

    Balázs