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.
Creating a column with no values allows you to create a blank column to be inserted into datasets where needed.
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.
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".