Support

Home > Tips and Tricks > Converting data types

Converting data types

Changing the data type of any column in a step is simple. In the input data section of the step, click the blue Data Type Button then select the new data type for the records in that column to be converted to.

You can also right click on the column, select the "Change Column Type" menu option and choose which type of data you would like the column to be.

Changing data types in formulas

In a Transform step, select a column in the output section. As long as the column was only brought from the input to the output sections, the formula in the Formula Ribbon will reference the previous step name and column name. You can modify that formula to convert the output column to a different data type by applying the TODATE, TOLOGICAL, TONUMBER and TOTEXT functions.

For example, say you added a Transform step to a previous step name "Sales" and moved the column "Store_Number" from the input to the output. The formula in the Filter Ribbon would be "=Sales.Store_Number". To conver the output column from a number to text you could change the formula to "=totext(Sales.Store_Number)".

Changing data types in the import settings

When a connection is made to a new data source, Lyza pre-determines the data type of each column. To change the data type of a column in a data connection, follow these steps:

Double click the data connection to open it
Click the "Edit Import Settings" link in the upper right
Click on the Data Type Button for the column you want to change
Select the new data type for the column

Note: When converting column data types in a data connection, some records my become highlighted in yellow. This indicates that those record contain data that is not compatible with the current data type specified for that column and those records will be dropped. To correct this problem, change the data type of the column to a type that is more compatible with your records.