{{ transformations:CreateListAction.png}}
====== 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 [[transformations:splitdelimitedtext|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.|
|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.|
\\ 
====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=====
  * [[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".