Detailed Description of Alter Format

Performs transformation of the input data format. The output data is given new data formats, either by removing or adding new column definitions. New columns are added behind existing columns of the input format, and can be initialized as part of the column definition. Columns can be replaced (the data type can be changed and values converted) by both removing and adding.

In the following example, the column data will be removed, then a new column newday will be added. Next, the column id will be converted to a string by first being removed, then added as a column with the same name, and evaluated with the expression toString(). Other format columns will remain unchanged.


Top of page

Example: Example
<step id='alterFormat' className='cz.adastra.cif.tasks.flow.AlterFormat'>
        <properties>
                <removedColumns>
                        <column name='id'/>
                        <column name='data'/>
                </removedColumns>
                <addedColumns>
                        <column name='newday' type='day'/>
                        <column name='id' type='string' expression='toString(id)'/>
                </addedColumns>
        </properties>
</step>

iWay Software