transformations:selectbylookup
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| transformations:selectbylookup [2021/07/15 12:51] – craigt | transformations:selectbylookup [2021/07/19 02:18] (current) – [Examples] craigt | ||
|---|---|---|---|
| Line 22: | Line 22: | ||
| =====Examples===== | =====Examples===== | ||
| - | **Objective:** Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).\\ | + | **Example:** Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).\\ |
| \\ | \\ | ||
| **Table 1:** River lengths. | **Table 1:** River lengths. | ||
| Line 43: | Line 43: | ||
| >Ignore case is " | >Ignore case is " | ||
| \\ | \\ | ||
| - | **Result: | + | **Result |
| ^River | ^River | ||
| | Nile | 6650|Mediterranean | | Nile | 6650|Mediterranean | ||
transformations/selectbylookup.txt · Last modified: 2021/07/19 02:18 by craigt