A program to recognize and reward our most engaged community members
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------------------------------"
