transformations:lookup
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:lookup [2015/04/27 19:30] – elenap | transformations:lookup [2021/04/04 00:01] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Map ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformations | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | When value is not found, three options are available: | + | When the value is not found, three options are available: |
* Keep old value | * Keep old value | ||
* Leave cell empty | * Leave cell empty | ||
* Put some predefined (default) value | * Put some predefined (default) value | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | * Used to replace common misspellings with the correct value. | ||
+ | * Used to replace abbreviations with the full value. | ||
+ | * Used to replace numeric codes with descriptive text values. | ||
- | **Table 1:** Canadian Olympic Champions 2014 | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Lookup table|Select the dataset that will serve as the lookup table.| | ||
+ | \\ | ||
+ | ====Mode settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Append new column|A new column (named "New name") will be created in the current dataset to hold the result of the lookup.| | ||
+ | |Replace in (column)|Upon a successful match in the lookup table, the return value will //replace// the original value in the current dataset.| | ||
+ | \\ | ||
+ | ====Columns that should match settings==== | ||
+ | ^Setting^Description^ | ||
+ | |This table|Select the column in the current dataset containing values that will be matched in the foreign dataset.| | ||
+ | |(Look up in column)|The column in the second dataset that will be used to find matching values in the current dataset.| | ||
+ | |Return from|Select the column in the second table from which values will be returned based on a match in the lookup column.| | ||
+ | \\ | ||
+ | ====No conditions met options==== | ||
+ | ^Setting^Description^ | ||
+ | |Keep original value|If a value does not have a match in the lookup table, keep the original value.| | ||
+ | |Make empty|If a value does not have a match in the lookup table, make the value // | ||
+ | |Default to|Options: // | ||
- | ^ Gold medalist | + | \\ |
- | | Dara Howell | + | =====Examples===== |
- | | Justine Dufour-Lapointe | + | |
- | | Kaillie Humphries | + | |
- | | Alex Bilodeau | + | |
- | | Heather Moyse | P.E.I. | + | |
- | | Charles Hamelin | + | |
- | **Objective: | + | **Objective: |
- | **Table | + | **Table |
- | ^ | + | ^Gold medalist |
- | | Quebec | + | | Dara Howell |
- | | QC | | + | | Justine Dufour-Lapointe |
- | | Que. | | + | | Kaillie Humphries |
- | + | | Alex Bilodeau | |
- | **Transformation: | + | | Heather Moyse |P.E.I. |
- | * Replace value in column: Province | + | | Charles Hamelin |
- | * Using table: | + | \\ |
- | * Look up in column: Old name | + | **Table 2:** Substitution lookup table |
- | | + | |
- | | + | |
+ | ^Old name ^New name ^ | ||
+ | | Quebec | ||
+ | | QC |Quebec | ||
+ | | Que. |Quebec | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Replace value in column: Province | ||
+ | >Using table: Table 2 | ||
+ | >Look up in column: Old name | ||
+ | >Replace with values from column: New name | ||
+ | >When not found: Keep original value | ||
+ | \\ | ||
**Result:** | **Result:** | ||
- | ^ Gold medalist | + | ^Gold medalist |
- | | Dara Howell | + | | Dara Howell |
- | | Justine Dufour-Lapointe | + | | Justine Dufour-Lapointe |
- | | Kaillie Humphries | + | | Kaillie Humphries |
- | | Alex Bilodeau | + | | Alex Bilodeau |
- | | Heather Moyse | women’s bobsleigh | + | | Heather Moyse |P.E.I. |
- | | Charles Hamelin | + | | Charles Hamelin |
- | + | \\ | |
+ | **Alternate result: | ||
+ | If " | ||
+ | |||
+ | ^Gold medalist | ||
+ | | Dara Howell | ||
+ | | Justine Dufour-Lapointe | ||
+ | | Kaillie Humphries | ||
+ | | Alex Bilodeau | ||
+ | | Heather Moyse |P.E.I. | ||
+ | | Charles Hamelin | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/lookup.txt · Last modified: 2021/07/19 02:31 by craigt