Data-flo
Data-floSource CodeCGPS
  • INTRODUCTION
    • What is Data-flo
    • Getting Started - Sign In
    • Privacy and Terms Of Service
    • Contact - Help & reporting errors
    • Change log
  • USING DATA-FLO
    • Data-flo site navigation
      • Transformations Page
      • Run Page
      • Canvas
    • Data
      • Bringing data in to Data-flo
      • Getting data out of Data-flo
      • Data Types
        • Boolean
        • Datatable
        • File
        • Graph
        • List
        • Map
        • Number
        • Text
    • Regular Expressions (RegEx)
    • Adaptors overview
      • Components of an adaptor
      • Binding types
        • Bind to Data-flo input
        • Bind to value
        • Bind to another transformation
    • Specific adaptors
      • add-column
      • append-to-list
      • calculate-time-difference
      • change-column-case
      • columns-concatenation
      • concatenate-text
      • create-microreact-project
      • csv-file-to-datatable
      • csv-to-datatable
      • datatable-columns
      • datatable-to-csv-file
      • datatable-to-graph
      • datatable-to-list
      • datatable-to-map
      • datatable-to-sqlite-file
      • date-to-text
      • dbf-file
      • dot-to-graph
      • download-file
      • dropbox-file
      • epicollect-project
      • extend-datatable
      • figshare-file
      • file-to-text
      • filter-blank-values
      • filter-columns
      • filter-list
      • filter-rows
      • filter-rows-numerically
      • force-directed-layout
      • format-date-column
      • forward-geocoding
      • ftp-file
      • gather-rows
      • google-drive-file
      • google-spreadsheet
      • graph-to-dot
      • join-datatables
      • list-to-datatable
      • lookup-map-value
      • merge-datatables
      • merge-lists
      • microreact-project
      • mysql-database
      • newick-leaf-labels
      • oracle-database
      • postgress-database
      • prepend-to-list
      • remove-columns
      • remove-duplicate-rows
      • rename-columns
      • replace-blank-values
      • replace-column-values
      • replace-text
      • replace-text-in-list
      • replace-value
      • reverse-geocoding
      • row-column-value
      • s3-file
      • select-columns
      • send-email-message
      • slice-datatable
      • slice-list
      • smb-file
      • sort-datatable
      • sort-list
      • split-column
      • split-datatable-rows
      • split-list
      • split-text
      • spread-rows
      • spreadsheet-file
      • sql-server-database
      • sqlite-database
      • sum-rows
      • text-template
      • text-to-file
      • unique-list-items
      • update-epicollect-entries
      • update-microreact-project
      • update-smb-file
      • upload-file-to-google-drive
      • upload-files-to-google-drive
      • url-builder
      • yaml-to-json
    • Building a data-flo
      • Debugging mode
      • Show detailed errors on Run Page
      • Permissions - Access Control
    • Tips & Tricks
  • TUTORIALS
    • Prep outbreak data for Microreact
    • Common use cases, solved
      • Fixing datatable headers
      • Select, remove, rename, reorder columns
      • Data in separate files
      • There's no single-column unique row ID (primary key)
      • Ensure non-dates stay non-dates
      • Connect directly to a database
      • Access files on a drive
Powered by GitBook
On this page
  • How to use 'Bind to value'
  • Examples
  • Regular Expressions
  • Convert "Bind to value" to secret input
  • Remove binding

Was this helpful?

  1. USING DATA-FLO
  2. Adaptors overview
  3. Binding types

Bind to value

Defining a hard-coded value that will be used every time the data-flo is run

PreviousBind to Data-flo inputNextBind to another transformation

Last updated 2 years ago

Was this helpful?

If the same value will be used every time the data-flo is run, then you can use 'Bind to value' and hard-code that input.

A few of the many use cases:

  • Defining a set of columns to be passed to the next adaptor

  • Naming a column

  • Defining a regular expression (RegEx) to identify specific values

  • Setting a numeric threshold for a filtering adaptor when the threshold doesn't change from day to day

TIP: if you add a bind-to-value and don’t type anything into the box, it assumes you’re binding to an empty value.

How to use 'Bind to value'

  1. Select the argument to bring up Binding Types

  2. Select "Bind to a value" to bring up the VALUE

Examples

This image shows "Bind to a value" interface for map, number, boolean, and text arguments.

Regular Expressions

When a wildcard or pattern-matching value is desired, you can use 'Bind to a value' and use a regular expression as the value. In the image above, the search-text adaptor is used with a regular expression to find all instances of a hyphen in the text input.

Convert "Bind to value" to secret input

Sometimes, you have a value in "bind to a value" you don't want others to see (e.g. passwords and tokens), so you can't share the data-flo as-is. In this case, you need to switch to " Convert to secret input" in the value menu.

Remove binding

When you click the "REMOVE BINDING" button, the argument reverts to its defaults or reverts to blank**.**

If you do not "remove binding" and simply leave the "value" field empty, your argument remains bound to a blank (null,empty) value.

Steps for Binding to a value in an argument with LIST data type
Examples of "Bind to value" in various data types
More about RegEx