LogoLogo
About
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
  • Airtable
    • Fetching Airtable Data
    • Creating and Modifying Airtable Records
    • Creating Airtable Reports
    • Exporting Airtable Reports
    • File Management
    • Submit Airtable Records for Approval
  • AWS S3
    • Listing Files
    • Retrieving Files
    • Uploading Files
    • Uploading CSV
    • Uploading Strings
    • Deleting Files
    • Deleting CSV
  • Azure Blob Storage
    • Uploading Files
    • Retrieving Files
  • Azure Service Bus
    • Sending Messages to Azure Service Bus Queue
    • Receiving Messages from Azure Service Bus Queue
  • Azure Translate
    • Translating A Document
  • Database
    • Retrieving Database Records
    • Updating Database Records
    • Creating Database Records
    • Deleting Database Records
  • Document Processing
    • Document Processing: Workflow Patterns and Best Practices
    • Document Processing with OCR
    • Extract Data from a Document
    • Extract Pages from a Document
    • Extract Tables from a Document
    • Extract a Subdocument
    • Extract Subdocuments
    • Getting Fields from a Document
    • Getting Tables from a Document
  • Google Cloud Storage
    • Dumping Files to Google Cloud Storage
    • Purging Files from Google Cloud Storage
    • Dumping CSVs to Google Cloud Storage
    • Purging CSVs from Google Cloud Storage
    • Enriching Questions
  • HTML
    • Extracting Tables from HTML
  • HTTP
    • GET Request
    • POST Request
    • DELETE Request
    • PATCH Request
    • PUT Request
    • HEAD Request
  • Hubspot
    • Fetching Data from Hubspot
  • Microsoft Excel
    • Opening Excel Files
    • Converting a File to Excel Format
    • Getting a Table from Excel
    • Converting Tables to Excel Workbooks
    • Renaming Excel Files
    • Creating a Merged Spreadsheet from Multiple Files
    • Getting an Excel Worksheet's Row
    • Getting an Excel Worksheet's Row's Cell
    • Getting an Excel Worksheet Cell's Column Label
    • Setting an Excel Worksheet Cell to a String
    • Getting an Excel Worksheet's Changelog
    • Apply Changelogs to an Excel Worksheet
    • Saving An Excel Worksheet
  • Microsoft Outlook
    • Email Operations
    • Getting Schedules
    • Moving Emails
  • Microsoft Power BI
    • Working with Power BI Objects
  • Microsoft SharePoint
    • Retrieving SharePoint Items
    • Uploading a File to SharePoint
    • Converting Data to SharePoint String
    • Moving a File to a Folder
    • Deleting a Folder
    • Getting a Folder
    • Uploading a String to a Folder
    • Creating and Retrieving a Folder
    • Deleting a File
  • Oracle Cloud Fusion
    • Fetching Data from Oracle Cloud Fusion
    • Adding New Records
    • Updating Records
    • Deleting Oracle Fusion Objects
    • Managing Attachments
    • Downloading Files from Oracle Fusion Objects
    • Detaching Files from Oracle Fusion Objects
  • Paycom
    • Working with Employee Details
    • Managing Punch Entries
  • Salesforce
    • Working with Salesforce Objects
    • Submitting Sales Objects for Approval
    • Creating Salesforce Reports
    • File Management
  • Servicenow
    • Retrieving Data
    • Manipulating Data
  • Slack
    • Sending Slack Messages
    • Reading Slack Messages
  • Stripe Pay
    • Fetch Data from Stripe
    • Add New Records
    • Working with Invoices
    • Deleting Objects from Stripe
  • Zendesk
    • Creating a Ticket
    • Updating a Ticket
    • Assigning a Ticket
    • Deleting a Ticket
    • Getting a Ticket
Powered by GitBook
On this page
  • Overview
  • Syntax
  • Inputs
  • Examples

Was this helpful?

Export as PDF
  1. Microsoft Excel

Creating a Merged Spreadsheet from Multiple Files

This procedure is part of the Excel Book. A newer version of the Book is available via the BDK (v2).

Overview

This procedure merges multiple spreadsheet files into one. You can rename columns, ignore specific columns, and choose how the files are joined.

Syntax

create a merged spreadsheet
  the files
  the join is "{join type}"
  the similar columns are "{original column name}", {new column name}"
  the ignored columns are "{ignored column}"

Inputs

  1. the files: The spreadsheet files to be merged. Supported formats are .csv and Excel. (required)

  2. type: The type of join to use when merging the files. (optional) Options:

    • outer (default)

    • inner

    • left

    • right

  3. original column name, new column name: A pair of column names that should be considered the same across spreadsheets. The first in each pair is the original column name, and the second is the new column name all occurrences will be renamed to.You can specify multiple column pairs, separated by commas. Example: "Name", "Full Name", "Date", "Event Date". (required)

  4. ignored columns: A list of columns to be excluded from the final merged spreadsheet. (optional)

Examples

1. Merging Two Files

the first file is "https://onedrive.live.com/file1.csv"
the second file is "https://s3.amazonaws.com/bucket-name/file2.xlsx"
create a merged spreadsheet with
    the files
    the join is "inner"
    the similar columns are "Name", "Full Name", "Date", "Event Date"
    the ignored columns are "ID", "Timestamp"

2. Merging Multiple Files

the spreadsheet files are "https://s3.amazonaws.com/bucket-name/sheet1.csv", "https://s3.amazonaws.com/bucket-name/sheet2.csv"
create a merged spreadsheet
    the spreadsheet files
    the similar columns are "Product ID", "ID"

Last updated 1 month ago

Was this helpful?