Redivis Documentation
API DocumentationRedivis Home
  • Introduction
  • Redivis for open science
    • FAIR data practices
    • Open access
    • Data repository characteristics
    • Data retention policy
    • Citations
  • Guides
    • Getting started
    • Discover & access data
      • Discover datasets
      • Apply to access restricted data
      • Create a study
    • Analyze data in a workflow
      • Reshape data in transforms
      • Work with data in notebooks
      • Running ML workloads
      • Example workflows
        • Analyzing large tabular data
        • Create an image classification model
        • Fine tuning a Large Language Model (LLM)
        • No-code visualization
        • Continuous enrollment
        • Select first/last encounter
    • Export & publish your work
      • Export to other environments
      • Build your own site with Observable
    • Create & manage datasets
      • Create and populate a dataset
      • Upload tabular data as tables
      • Upload unstructured data as files
      • Cleaning tabular data
    • Administer an organization
      • Configure access systems
      • Grant access to data
      • Generate a report
      • Example tasks
        • Emailing subsets of members
    • Video guides
  • Reference
    • Your account
      • Creating an account
      • Managing logins
      • Single Sign-On (SSO)
      • Workspace
      • Studies
      • Compute credits and billing
    • Datasets
      • Documentation
      • Tables
      • Variables
      • Files
      • Creating & editing datasets
      • Uploading data
        • Tabular data
        • Geospatial data
        • Unstructured data
        • Metadata
        • Data sources
        • Programmatic uploads
      • Version control
      • Sampling
      • Exporting data
        • Download
        • Programmatic
        • Google Data Studio
        • Google Cloud Storage
        • Google BigQuery
        • Embedding tables
    • Workflows
      • Workflow concepts
      • Documentation
      • Data sources
      • Tables
      • Transforms
        • Transform concepts
        • Step: Aggregate
        • Step: Create variables
        • Step: Filter
        • Step: Join
        • Step: Limit
        • Step: Stack
        • Step: Order
        • Step: Pivot
        • Step: Rename
        • Step: Retype
        • Step: SQL query
        • Variable selection
        • Value lists
        • Optimization and errors
        • Variable creation methods
          • Common elements
          • Aggregate
          • Case (if/else)
          • Date
          • DateTime
          • Geography
          • JSON
          • Math
          • Navigation
          • Numbering
          • Other
          • Statistical
          • String
          • Time
      • Notebooks
        • Notebook concepts
        • Compute resources
        • Python notebooks
        • R notebooks
        • Stata notebooks
        • SAS notebooks
        • Using the Jupyter interface
      • Access and privacy
    • Data access
      • Access levels
      • Configuring access
      • Requesting access
      • Approving access
      • Usage rules
      • Data access in workflows
    • Organizations
      • Administrator panel
      • Members
      • Studies
      • Workflows
      • Datasets
      • Permission groups
      • Requirements
      • Reports
      • Logs
      • Billing
      • Settings and branding
        • Account
        • Public profile
        • Membership
        • Export environments
        • Advanced: DOI configuration
        • Advanced: Stata & SAS setup
        • Advanced: Data storage locations
        • Advanced: Data egress configuration
    • Institutions
      • Administrator panel
      • Organizations
      • Members
      • Datasets
      • Reports
      • Settings and branding
    • Quotas and limits
    • Glossary
  • Additional Resources
    • Events and press
    • API documentation
    • Redivis Labs
    • Office hours
    • Contact us
    • More information
      • Product updates
      • Roadmap
      • System status
      • Security
      • Feature requests
      • Report a bug
Powered by GitBook
On this page
  • Overview
  • Building lists
  • Importing lists
  • List types

Was this helpful?

Export as PDF
  1. Reference
  2. Workflows
  3. Transforms

Value lists

Last updated 6 months ago

Was this helpful?

Overview

Value lists allow you to persist a group of values in a list, for use throughout a workflow. You can centrally view and edit this list, and any changes to it will be pushed to all transforms where it is being used.

This may be useful in a scenario where a list of diagnosis codes are entered in multiple filters that may change over time as you build you analysis, or when you have a single parameter you are using in multiple places that you want to be able to quickly change anywhere.

Building lists

To create and update value lists, you can click the Lists button at the top left of workflow tool top bar.

You can create, modify, and delete lists from this interface.

For bulk importing you can copy/paste values from any standard spreadsheet program, or import them from a csv or json file. Please note that string list values should not be quoted — learn more about list types below.

You can then reference the list in transforms throughout your workflow anywhere that you could input multiple values.

If you update the values within a list, all transforms that reference the list will be marked as .

Importing lists

Values can be copied into lists from any spreadsheet program by directly using the clipboard. For bulk or scripted actions, you may also import multiple lists as a JSON or CSV file. Note that any list exports will follow the same format.

CSV specification

Each variable in your CSV will represent one list, with the first row containing the name of the list. E.g.:

Fruits

Vegetables

Item_codes

Strawberry

Broccoli

1

Tomato

Asparagus

2

Apple

Spinach

3

JSON specification

The same set of value lists can be imported via JSON, with the following format:

[
    { 
        "name": "Fruits",
        "values": ["Strawberry", "Tomato", "Apple"]
    },
    { 
        "name": "Vegetables",
        "values": ["Broccoli", "Asparagus", "Spinach"]
    },
    { 
        "name": "Item_codes",
        "values": ["1", "2", "3"]
        // This is identical:
        // "values": [1, 2, 3]
    },
]

List types

Redivis will automatically determine the most specific type for all the values in a list, falling back to the "universal type" of string.

For example, these combinations will yield the corresponding specific types and can be compared to the following types:

Values

Type

Can compare to

1, 2, 3

Integer

Integer, Float, String

1, 2.0, 3

Integer

Integer, Float, String

1, 1.0, 1.1

Float

Float, String

1, 2.0, a

String

String

1971-01-01, 1972-02-02, 1973-03-03

Date

Date, String

1971-01-01, a, b

String

String

1970-01-01 12:00:00, 1970-01-01 12:30:00

DateTime

DateTime, Date, String

Note list values should never be quoted, unless you specifically want to match against a quote character.

All variables in Redivis have a . When using lists to filter rows the list type needs to be the same (or coercible to) the variable that is being filtering on.

edited
defined type