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
transformations:lookuprename [2021/07/15 12:42] – [Examples] craigttransformations:lookuprename [2021/07/19 02:19] (current) – [Examples] craigt
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").
transformations/lookuprename.txt · Last modified: 2021/07/19 02:19 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki