Sometimes you may need to split a singe field into multiple fields. You can do this by using the Split-function in the data movement process.
We have a staging table that looks like the one below and we would like to split the fields using space as the separator.
Create a table on the DWH with two fields, "Column1" and "Column2". Drag the field “Column1” on stage to the field “Column1” on DWH to initiate the data movement. In the dialogue, select Split as the Method.
In the Add Split Field-dialogue, input the separator (we use space in this example), make sure the Source Field is correct and choose the Destination Fields
The result on the data warehouse should look like this:
This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-24.