transformations:createlist
Table of Contents
CREATE LIST
Category: Create / Generate
Description
This action creates a 1-column list of up to 100 manually entered values. If several columns are required, the values can be entered separated by a delimiter (e.g. comma) and then split using the Split delimited text action afterward.
Use cases
- This action can be used to keep reference lists in the project without needing to load them from external files.
- Using 2-column mode, create static lookup tables to be used in the workflow.
- Creating a column with no values allows you to create a blank column to be inserted into datasets where needed.
- Create a single-column, single-cell table with a static value to be Peek'd into other datasets.
Action settings
| Setting | Description |
|---|---|
| Paste list | Paste in a list of values that has been copied to the clipboard from another application. A dialog of paste options will appear when this is selected (see below). |
| Copy list | Copy the list of values in this action to the clipboard, to be pasted into another application. |
| Clear list | Clear all current values from the list. |
| # columns | Select whether to create one or two columns within this action. Options: 1 column or 2 column. |
| Column name | Enter the name of the column generated (or both columns names if 2 columns was selected). |
| List values | Enter the list of values under each created column. Use the Add more values button to insert another blank row into the value list. |
Paste values options
| Option | Description |
|---|---|
| List doesn't have a header | Check this if the copied list does not have a header row as the first row. |
| Decimal | Select whether decimal places are displayed using a Point or Comma. |
| Replace existing list | Choose this option to clear all current list values and replace them with the pasted values. |
| Append to existing list | Choose this option to insert the copied values after the values in the existing list. |
Remarks
All entered values are stored in plain text in the project file. Do not use the action to store confidential or sensitive information in projects.
Examples
Example #1
Create a static lookup table of survey response values to their corresponding labels.
After (result table)
| Response value | Label |
|---|---|
| 1 | Very poor |
| 2 | Poor |
| 3 | Neutral |
| 4 | Good |
| 5 | Very good |
Action parameters
2 columns
Column names: Response value, Label
List values: 1, Very Poor; 2, Poor; 3, Neutral; 4, Good; 5, Very good
Example #2
Create a list of department names.
After (result table)
| Department |
|---|
| HR |
| Accounting |
| Marketing |
| Sales |
| Customer Service |
| Operations |
| IT |
Action parameters
Column names: Department
List values: HR, Accounting, Marketing, Sales, Customer Service, Operations, IT.
Community examples
- Optional calculations with columns (Project; Module: Main; Group: Tab 1; Table: Source data; Action position: 1)
- Use case for Repeat Rows (Project; Module: Main; Group: Tab 1; Table: Source data; Action position: 3)
- How to look up and replace a string of text (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 1)
- Substring Query (Project; Module: Main; Group: Tab 1; Table: Table 2; Action position: 2)
- Example of using Interval Merge (Project; Module: Main; Group: Tab 1; Table: Sample data; Action position: 1)
- Join 2 tables with multi criterions equal and not equals in where (Project; Module: Main; Group: Tab 1; Table: Mvt (2);
Action position: 2)
Shortcuts
Fast ways to create the action:
- Press the "Add data" menu button. Pick "Generate data".
transformations/createlist.txt · Last modified: 2025/02/09 12:14 by craigt