Contents x
    Filter
    • 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Filter

    • Updated on 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    The Filter Node is used to rename, reclassify, or filter out a column or group of columns when connected to a source node or a preceding node that is not an output or export node. This node will output ALL the columns from the preceding node that are identified with the “include” check set.


    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    Included ColumnsThe set of columns from the preceding node to be included. Defaults to all columns being included. Individual columns can be removed from the output by unchecking the column name in the dropdown list.
    New NameName of the column header in this node's output.
    New TypeData type of the column for this node's output.

    Actions

    ActionDescription
    Refresh Columns from Previous NodeUpdates the Included Columns dropdown list from the parent node.
    Rename a ColumnRenames any source column in the “New Name” field.
    Change Data Type a ColumnReclassifis any source column in the “New Type” field. Note that the data type must be compatible with source data reclassification or an error will result. For example, a “string” data source will generate an error if it is converted to a “double”.
    PreviewThe Preview button is selected to preview the output data, including any updated exclusions and column data types.

    Allowed Date Formats

    When converting from a String data type to a Date/Time, the following date strings are allowed:

    • yyyyMMdd
    • dd-MM-yyyy
    • yyyy-MM-dd
    • MM/dd/yyyy
    • yyyy/MM/dd
    • dd MMM yyyy
    • dd MMMM yyyy
    • yyyyMMdd HHmm
    • dd-MM-yyyy HH:mm
    • yyyy-MM-dd HH:mm
    • MM/dd/yyyy HH:mm
    • yyyy/MM/dd HH:mm
    • dd MMM yyyy HH:mm
    • dd MMMM yyyy HH:mm
    • yyyyMMddHHmmss
    • yyyyMMdd HHmmss
    • dd-MM-yyyy HH:mm:ss
    • yyyy-MM-dd HH:mm:ss
    • MM/dd/yyyy HH:mm:ss
    • yyyy/MM/dd HH:mm:ss
    • dd MMM yyyy HH:mm:ss
    • dd MMMM yyyy HH:mm:ss
    • yyyy-MM-dd HH:mm:ss.SSS
    • EEE MMM dd HH:mm:ss zzz yyyy
    Was this article helpful?
    What's Next