The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hi Janet,
The "Match Column on order" from the context menu is dependent on column type, but you have complete control via the Append Helper.
Table 1 (Text, Date, Numeric)
Table 2 (Date, Numeric, Text)
The quickest way is to use the right Click "Match Columns on order", then edit the append.
By default, the final column type will be based on the first table in the append, so this is unlikely to work straight away.
You can't fix it by changing the column type directly in the table, because the data has already been destroyed by the Append. But you can edit the Append and change the output column. Click the drop down or right click on the Appended table and select Edit Append, then choose your column types (usually Text if you want to store all 'data types'.)
This results in the following table
Regards,
Steve.
Hi Janet, The "Match Column on order" from the context menu is dependent on column type, but you have complete control via the Append Helper. Table 1 (Text, Date, Numeric) Table 2 (Date, Numeric, Text) The quickest way is to use the right Click "Match Columns on order", then edit the append. By default, the final column type will be based on the first table in the append, so this is unlikely to work straight away. You can't fix it by changing the column type directly in the table, because the data has already been destroyed by the Append. But you can edit the Append and change the output column. Click the drop down or right click on the Appended table and select Edit Append, then choose your column types (usually Text if you want to store all 'data types'.) This results in the following table Regards, Steve. ------------------------------Steve CaielsProfessional ServicesAltair-------------------------------------------------------------------------Original Message:Sent: 07-09-2020 12:54 PMFrom: Janet GrimsleySubject: Data Prep Append TablesIt appears that Data Prep will only work with a strict append. Just need to confirm as I am ingesting a txt file that has 3 types of information. I am breaking it apart and need to arrange it differently. The column names are not the same for each of the 3 record types. I want to ignore the column names and types. The append will be based on the position of the column.I can append in the export utility, if not as a table inside of Data Prep.------------------------------Janet GrimsleyVP, Business IntelligenceThe Fauquier BankWarrenton VA5403490215------------------------------"
Hi Janet,In DPS prepare page you can select all your tables in the order you need, then right click and select the Append helper.In the Append helper you can map each column.RegardsMo------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerAltair Engineering-------------------------------------------------------------------------Original Message:Sent: 07-09-2020 12:54 PMFrom: Janet GrimsleySubject: Data Prep Append TablesIt appears that Data Prep will only work with a strict append. Just need to confirm as I am ingesting a txt file that has 3 types of information. I am breaking it apart and need to arrange it differently. The column names are not the same for each of the 3 record types. I want to ignore the column names and types. The append will be based on the position of the column.I can append in the export utility, if not as a table inside of Data Prep.------------------------------Janet GrimsleyVP, Business IntelligenceThe Fauquier BankWarrenton VA5403490215------------------------------"
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
