User Tools

Site Tools


transformations:lookuprename

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
transformations:lookuprename [2021/04/12 01:56] craigttransformations:lookuprename [2021/07/19 02:19] (current) – [Examples] craigt
Line 1: Line 1:
 {{ transformations:RenameColumnsAction.png}} {{ transformations:RenameColumnsAction.png}}
-====== RENAME COLUMNS  WITH LOOKUP ======+====== RENAME COLUMNS BY LOOKUP ======
 Category: Transform / Advanced\\ Category: Transform / Advanced\\
  
Line 30: Line 30:
 =====Examples===== =====Examples=====
  
-**Objective:** Rename the columns in Table 1 using the old/new name pairings in Table 2.\\+**Example:** Rename the columns in Table 1 using the old/new name pairings in Table 2.\\
 \\   \\  
 **Table 1:**  Source table columns. **Table 1:**  Source table columns.
Line 50: Line 50:
 >Column with new names is "New names" >Column with new names is "New names"
 \\  \\ 
-**Result:** +**Result table:** 
 ^FirstName  ^LastName  ^Address  ^City  ^ST  ^Zip Code  ^ ^FirstName  ^LastName  ^Address  ^City  ^ST  ^Zip Code  ^
 Notice that "ST" wasn't renamed to "State" due to case issues ("ST" vs. "St"). Notice that "ST" wasn't renamed to "State" due to case issues ("ST" vs. "St").
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1432/4|Dynamic transformation]] ([[https://community.easymorph.com/uploads/short-url/1wu0gGctfVxSdnVCjW8GdUymqcw.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Result//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1475/1|Finding all projects with particular action]] ([[https://community.easymorph.com/uploads/short-url/cM8AssOT6zQXD8JDr9adUAy2sDM.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Projects with sandboxes//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1803/3|Create dynamic list from delimited text (dynamic split/dynamic generate list)]] ([[https://community.easymorph.com/uploads/short-url/vd59gCPQiP8m4hiFPZmYiRDKW31.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Output//; Action position: //5//)
  
 \\  \\ 
transformations/lookuprename.txt · Last modified: 2021/07/19 02:19 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki