User Tools

Site Tools


transformations:createlist

Differences

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

Link to this comparison view

Next revision
Previous revision
transformations:createlist [2018/07/22 15:50] – created dmitrytransformations:createlist [2023/01/25 20:13] (current) – [Use cases] craigt
Line 1: Line 1:
-===== Create list =====+{{ transformations:CreateListAction.png}} 
 +====== CREATE LIST ====== 
 +Category: Create / Generate\\
  
-This action creates a 1-column list of up to 100 manually entered values. It can be used for keeping various reference lists right in project, without the need to load them from external files.+\\  
 +=====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.\\
  
-If several columns are required, the values can be entered separated by delimiter (e.gcomma) and then split using the [[transformations:splitdelimitedtext|"Split delimited text"]] action afterwards.+\\  
 +=====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 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".
  
-Note that all entered values are stored in plain text in project file. Do not use the action to store confidential or sensitive information in projects. 
transformations/createlist.1532289006.txt.gz · Last modified: 2018/07/22 15:50 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki