Data-flo Docs
  • About Data-flo
    • Data-flo Major Update in April 2024
      • Migrating your workflows into the latest version of Data-flo
        • Streamlined adaptors
        • Deprecated adaptors
        • New and retained adaptors
    • Change Log
    • Privacy and Terms of Service
    • Open source software used by Data-flo
  • Data-flo Basics
    • Account
    • Navigation
    • Terminology
    • Interface Icons
    • Data-flo's building blocks: Adaptors
      • Using adaptors to import data
      • Using adaptors to process data
      • Using adaptors to export data
    • Combining adaptors to create workflows
      • Creating a workflow
        • Building a workflow from scratch
        • Cloning an existing workflow
        • Importing a .dataflo file
      • Testing your workflows
      • Running your workflows
      • Accessing your workflows
  • Adaptor reference guide
    • add-column
    • add-jittering
    • add-value-to-dictionary
    • aggregate-rows
    • append-datatables
    • append-lists
    • append-to-list
    • apply-force-directed-layout
    • calculate-column
    • calculate-time-difference
    • change-column-case
    • compare-columns
    • concatenate-columns
    • concatenate-text
    • convert-date-to-text
    • convert-list-to-datatable
    • convert-text-to-datatable
    • convert-text-to-list
    • create-dictionary-from-datatable
    • create-google-drive-folder
    • create-graph-from-datatable
    • create-graph-from-dot
    • create-list-from-datatable
    • create-text-from-template
    • duplicate-column
    • export-file-to-google-drive
    • export-file-to-smb-share
    • export-graph-to-dot-file
    • export-text-to-file
    • export-to-csv-file
    • export-to-dbf-file
    • export-to-google-sheet
    • export-to-microreact-project
    • export-to-sqlite-file
    • filter-list
    • filter-rows
    • find-value-in-dictionary
    • find-value-in-list
    • format-date-column
    • format-time-column
    • geocoding
    • import-file-from-dropbox
    • import-file-from-figshare
    • import-file-from-google-drive
    • import-file-from-http-request
    • import-file-from-s3
    • import-file-from-smb-share
    • import-file-from-url
    • import-from-csv-file
    • import-from-dbf-file
    • import-from-epicollect-project
    • import-from-excel-file
    • import-from-google-sheet
    • import-from-json-file
    • import-from-microreact-project
    • import-from-mysql
    • import-from-oracle
    • import-from-postgres
    • import-from-spreadsheet-file
    • import-from-sql-server
    • import-from-sqlite
    • import-list-from-text-file
    • import-text-from-file
    • join-datatables
    • list-datatable-columns
    • list-newick-leaf-labels
    • map-column-values
    • prepend-to-list
    • query-datatable
    • remove-columns
    • remove-duplicate-list-values
    • remove-duplicate-rows
    • rename-columns
    • rename-newick-leaf-labels
    • replace-blank-values
    • replace-values-in-columns
    • replace-values-in-list
    • replace-values-in-text
    • reshape-long-to-wide
    • reshape-wide-to-long
    • reverse-geocoding
    • run-openai-model
    • run-replicate-model
    • run-workflow
    • sample-datatable
    • select-columns
    • select-list-values
    • select-rows
    • send-email-message
    • sort-datatable
    • sort-list
    • split-column
    • split-geographical-coordinates
    • split-list
    • summarise-datatable
    • transform-columns
    • workflow-repeater
  • Applying Data-flo
    • Basics in Minutes!
      • Quick Workflow
        • Step 1: Configure a solo adapter to view data.
        • Step 2: Add and link a second adaptor.
        • Step 3: Add a value.
        • Step 4: Complete the workflow.
        • Step 5: Run the workflow.
        • Step 6: Share the workflow.
  • API
    • Data-flo API
    • API Access Tokens
  • Support
    • Contact and Feedback
    • Private Installations
Powered by GitBook
On this page
  • Description
  • Inputs
  • Outputs
  • Examples
  • Example 1: Default behaviour.
  • Example 2: Add column with value.
  • Use Cases
  1. Adaptor reference guide

add-column

PreviousAdaptor reference guideNextadd-jittering

Last updated 1 year ago

Description

add-column adaptor can be used to create a new column at the end of a datatable.

By default, the cells on the newly added column will be empty, this can be changed by setting a value. To move the new column to a different position in the datatable, use the to reorder the columns.

To add different values to each row of the new column, use the adaptor.

Inputs

data Type: datatable Required: Yes The datatable to which the new column will be added.

column name Type: text Required: Yes The name of the new column to be added.

value Type: text Required: No A value to be added to the column cells. If unspecified, empty values will be added.

Outputs

data Type: datatable A datatable with the new column added.

Examples

Example 1: Default behaviour.

Inputs:

data

Month
Sales (USD)

Jan

1458

Feb

9874

column name: Year

Outputs:

data:

Month
Sales (USD)
Year

Jan

1458

Feb

9874

-> Added column Year to the datatable with empty values.

Example 2: Add column with value.

Inputs:

data:

Month
Sales (USD)

Jan

1458

Feb

9874

column name: Year

value: 2024

Outputs:

data:

Month
Sales (USD)
Year

Jan

1458

2024

Feb

9874

2024

-> Added column Year to the datatable with the value 2024.

Use Cases

  • Add a column for data sources to the datatables before merging to track data origin

  • Use Data-flo to create a spreadsheet including some existing data, as well as some standardised empty columns for users to fill in later.

  • When joining two datatables, and one is missing one column which is found in the second, this adaptor can be used to provide values for the missing column.

  • During data cleaning or transformation, users may need to transform the data in a way that requires the creation of a new column in order to retain the originally formatted data in the original column. This can include tasks like formatting dates, converting units, or categorizing data.

select-columns adaptor
map-column-values