User Tools

Site Tools


transformations:createlist

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:createlist [2021/03/14 01:31] craigttransformations:createlist [2023/01/25 20:12] – [Use cases] Add Use Case for blank columns. craigt
Line 1: Line 1:
 {{ transformations:CreateListAction.png}} {{ transformations:CreateListAction.png}}
 ====== CREATE LIST ====== ====== CREATE LIST ======
-Category: Create / Generate+Category: Create / Generate\\
  
 +\\ 
 =====Description===== =====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 [[transformations:splitdelimitedtext|Split delimited text]] action afterward.+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 [[transformations:splitdelimitedtext|Split delimited text]] action afterward.\\
  
-Note that 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.\\+\\  
 +=====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 appended to datasets where needed.
  
 \\  \\ 
Line 16: Line 21:
 |Column name|The name of the generated field in the output dataset.| |Column name|The name of the generated field in the output dataset.|
 |List values|This section displays the list of created values.  Use the //Add more values// button to insert another blank row into the value list.| |List values|This section displays the list of created values.  Use the //Add more values// button to insert another blank row into the value list.|
 +\\ 
 ====Paste values options==== ====Paste values options====
 ^Option^Description^ ^Option^Description^
Line 24: Line 30:
  
 \\  \\ 
-=====Use cases===== +=====Remarks===== 
-This action can be used for keeping reference lists right in the project without the need to load them from external files.+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===== 
 +  * [[https://community.easymorph.com/t//1221/2|Optional calculations with columns]] ([[https://community.easymorph.com/uploads/short-url/xdMJcC4iCkM1HopeOv5m0VqEuvh.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Source data//; Action position: //1//) 
 +  * [[https://community.easymorph.com/t//1297/3|Use case for Repeat Rows]] ([[https://community.easymorph.com/uploads/short-url/rdUnMPy0VfogVZOnROOoH2JaVUT.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Source data//; Action position: //3//) 
 +  * [[https://community.easymorph.com/t//1551/2|How to look up and replace a string of text]] ([[https://community.easymorph.com/uploads/short-url/dvCtD7gg0AHUtXZ7tmQmuHflSYU.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //1//) 
 +  * [[https://community.easymorph.com/t//1817/5|Substring Query]] ([[https://community.easymorph.com/uploads/short-url/sUDlB2uHCazeCdBqFSik6tCvu9r.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 2//; Action position: //2//) 
 +  * [[https://community.easymorph.com/t//1851/1|Example of using Interval Merge]] ([[https://community.easymorph.com/uploads/short-url/3ROZA38vhs9S7bXLcNKPIjudF61.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Sample data//; Action position: //1//) 
 +  * [[https://community.easymorph.com/t//2041/6|Join 2 tables with multi criterions equal and not equals in where]] ([[https://community.easymorph.com/uploads/short-url/kNkqMsDYMJjzjiN4C5g8O4g3YlA.morph|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: 2023/01/25 20:13 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki