Skip to main content Skip to complementary content

Defining the column filter component

Procedure

  1. Next to the tReplicate component definition, enter the addComponent {} function and its setComponentDefinition {} and setSettings {} functions and parameters to add and label the tFilterColumns component.
    // filter data columns - remove 'marriageStatus'
    addComponent {
    	setComponentDefinition {
    		TYPE: "tFilterColumns",
    		NAME: "tFilterColumns_1",
    		POSITION: 512, 224
    	}
    	setSettings {
    		LABEL : "filter_columns"
    }
  2. Next to the setSettings {} function, enter an addSchema {} function and its addColumn {} sub-functions to define the schema for the output flow.

    In this example, just copy the column settings defined in the previous component, with the marriageStatus column removed.

    	addSchema {
    		NAME: "tFilterColumns_1",
    		CONNECTOR: "FLOW"
    		addColumn {
    			NAME: "name",
    			TYPE: "id_String"
    		}
    		addColumn {
    			NAME: "gender",
    			TYPE: "id_String"
    		}
    		addColumn {
    			NAME: "age",
    			TYPE: "id_Integer",
    			LENGTH: 2
    		}
    		addColumn {
    			NAME: "city",
    			TYPE: "id_String"
    		}
    	}

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!