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

    Filter

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

    Description

    The Filter Node renames, reclassifies, or filters 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 outputs 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 ColumnReclassifies any source column in the “New Type” field. Note that the data type must be compatible with the 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”.
    PreviewOnce the node is configured, the output, including any exclusions and column data type changes, can be previewed at any time.

    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