LogoLogo
  • Docs
  • Connector Configuration
  • Knowledge Base
  • Changelog
  • Connector Configuration
  • ActiveCampaign
  • Airtable
  • Asana
  • AWS
    • AWS SNS
  • Azure Cognitive Services
  • Blackboard
  • CloudFlare
    • CloudFlare Lists
  • DeepAI
  • DocuSign
  • Dropbox
  • Facebook Business
  • Freshdesk
  • Google
  • Highrise
  • Hubspot
  • Imperva
  • Jira
  • Jotform
  • LinkedIn
  • Mailchimp
  • Microsoft
  • Microsoft Dynamics 365 CRM
  • Monday
  • Open AI
  • Pipedrive
  • Quickbooks
  • Redmine
  • Salesforce
  • Schoology
  • Screenshot API
  • ServiceNow
  • Shopify
  • Slack
  • Snowflake
  • Trello
  • Twilio
  • Twitter
  • Typeform
  • Utilities
    • AI
    • AppEvents
    • Controls
      • Condition
      • Counter
      • Digest
      • Each
      • Join
      • Join Each
      • On Start
      • Set Variable
      • Switch
    • Converters
      • Archive
      • CSV to HTML
      • CSV to JSON
      • CSV to XLSX
      • Data URI to File
      • HTML to CSV
      • HTML to JSON
      • HTML to XLSX
      • JSON to CSV
      • JSON to HTML
      • JSON to XLSX
      • XLSX to CSV
      • XLSX to HTML
      • XLSX to JSON
    • CSV
      • Add Column
      • Add Row
      • Add Rows
      • Create CSV
      • Delete Columns
      • Delete Rows
      • Export CSV
      • Get Cell
      • Get Row
      • Get Rows
      • Import CSV
      • Rename Column
      • Update Rows
    • Email
    • HTTP
      • Delete
      • Dynamic Webhook
      • GET
      • PATCH
      • POST
      • PUT
      • Response
      • Uptime
      • Webhook
    • Language
    • Tasks
      • Request Approval
      • Request Approval Email
    • Test
      • After All
      • Assert
      • Before All
      • Call Count
      • Join
      • Process E2E Results
      • Tick
    • Timers
      • Scheduler
      • Timer
      • Wait
    • Weather
    • XML
      • JSON to XML
      • Validate XML
      • XML to JSON
      • XPath
    • Storage
      • Clear
      • Find
      • Get
      • On Item Added
      • On Item Removed
      • On Item Updated
      • Remove
      • Save To File
      • Set
    • RSS
      • Get Feed
      • New Feed Item
    • FTP
      • Create Directory
      • Download File
      • Get File Info
      • New File
      • Remove Directory
      • List
      • Remove File
      • Rename File
      • Upload File
    • Forms
      • Form Action
      • Form Trigger
    • Filters
      • Contains
      • Equals
      • Greater Than
      • Identity
      • Is Not Empty
      • Less Than
      • Modulo
      • Not Equal
      • Range
    • Files
      • Archive File
      • Download File
      • Load File
      • Load File Lines
      • Remove File
      • Save File
  • Xero
  • Zendesk Chat
  • Zendesk Tickets
  • Zoho
Powered by GitBook
On this page
  • Overview
  • Usage
  • Instructions

Was this helpful?

Export as PDF
  1. Utilities
  2. CSV

Delete Columns

Overview

The DeleteColumns component removes specific columns from a CSV file. It allows users to define which columns to delete, using either column names (if headers exist) or column indices.

Usage

Input Parameters

Parameter
Type
Required
Description

withHeaders

boolean

✅

Set to true if the first row represents column names (CSV header) and should be used to identify columns.

Output Parameters

Parameter
Type
Description

fileId

string

The ID of the processed CSV file.

Instructions

  1. Determine Column Identification Method

    • If the first row contains column names, set withHeaders to true. This ensures the correct columns are deleted based on their names.

    • If column names are not available, columns are identified by index.

  2. Select Columns to Remove

    • Specify the columns you want to delete.

    • Ensure the correct format is used for column identification.

  3. Processing

    • The component removes the selected columns and generates a new CSV file.

    • The modified file is returned with a new fileId.

  4. Output

    • The processed file can be downloaded or used as input for further data processing.


PreviousCreate CSVNextDelete Rows

Last updated 3 months ago

Was this helpful?