Filter columns node

This node allows you to keep or remove columns that match the rule you define in the configuration of the node. In result, if you use the data transformation diagram that uses this node in the workflow, the system removes the matching columns in the file used in the workflow.

Node configuration


  1. In the upper right corner of the pop-up, click the Arrow down icon icon.
  2. Select one of the following options:
    • Remove columns - This option deletes columns that match the conditions you define in the further steps.
    • Keep columns - This option keeps only the columns that match the conditions you define in the further steps. The columns that don’t match the conditions are removed.
  3. From the dropdown list, select one of the logical operators:
    • Equal
    • Not equal
    • Ends with
    • Starts with
    • Contain
    • Not contain
  4. In the text field, enter the value.
  5. To add more conditions, click Add condition.
  6. Repeat steps 1-4.
  7. Confirm the settings by clicking Apply.

Example of use


While importing a list of transactions, you can edit out unnecessary columns. In this example, these are any columns that include an underscore in their name (import_type, payment_info) and columns whose name is exactly customers.

Click to see example file

price,customer,orderId,payment_info,date,import_type
10.99,John Doe,123345,cash,12.03.2022,toSynerise
4.99,Dwight Addams,122345,cash,12.03.2022,toSynerise
8.99,Andrew Malone,112345,cash,12.03.2022,toSynerise

The final configuration of data transformation diagram
The final configuration of data transformation diagram
  1. Start the diagram with Data Input.
  2. In the configuration of the node, upload a sample file.
  3. Add the Filter columns node.
  4. In the configuration of the node:
    1. Select Remove columns.
    2. Add the following conditions:
      • Contain _
      • Equal customer
      The configuration of the Filter columns node
      The configuration of the Filter columns node
    3. Confirm by clicking Apply.
  5. Add the Data Output node.
    Result: You can use this transformation in the Automation workflow to import or export files with the structure presented in this example.
    The output of data transformation
    The output of data transformation
😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker