Altering data types

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Altering data types

The Alter Data Type action allows you to change the data type of one or more columns in a target table. You can also configure this action to Warn/Error for non-existent field(s) at runtime

Set option for non-existent columns.
Drag column(s) to be changed.
Select new data type.
Indicator shows if column will actually be changed.

Possible applications include:

Change a field containing numbers that requires display of leading zeros (e.g., zip code or organizational code) from integer to string
Change a field used for calculations from a string to a numeric type

Alter a data type

Drag the Alter Data Type icon onto the design surface.
On the Connections tab , enter a Name and a Description to identify the action, then select the database and table:
- Database Connection – Select the database in which to change the data type(s), or choose New Database Connection to establish a new connection.
- Table Name – Select the table in which to change the data type(s).
On the Configuration tab :
- Available Columns – Contains a list of the columns for which the data type can be changed.
- Columns to Alter – Contains the columns that have been chosen for data type alteration. Data types that will actually be changed by executing the action are indicated by a pencil icon in the Status field, based on the current state of the transient table.
- Use the single right or left arrow icon to move a selected column to or from the list of columns to be altered, or use the double right or left arrow icons to move all columns.
- To change a column’s data type, click on the Data Type for that column in Columns to Alter, and then select another data type.
- To add a new column, enter a name at the top of Columns to Alter, and click the Add icon. You can then change the data type of the new column.
- Select the Warn or Error option to indicate what happens when any of the selected columns do not exist. Warnings appear in the output, while errors prevent the action from executing.

Last modified: Thursday December 19, 2024

Is this useful?

Yes No