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/01/29 23:20] – dmitry | transformations:lookup [2021/04/04 00:01] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Map ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformations | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | When value not found three options available: | + | When the value is not found, three options |
* Keep old value | * Keep old value | ||
* Leave cell empty | * Leave cell empty | ||
* Put some predefined (default) value | * Put some predefined (default) value | ||
+ | |||
+ | \\ | ||
+ | =====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. | ||
+ | |||
+ | \\ | ||
+ | =====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 //empty//.| | ||
+ | |Default to|Options: | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Table 1:** Canadian Olympic Champions 2014 | ||
+ | |||
+ | ^Gold medalist | ||
+ | | Dara Howell | ||
+ | | Justine Dufour-Lapointe | ||
+ | | Kaillie Humphries | ||
+ | | Alex Bilodeau | ||
+ | | Heather Moyse |P.E.I. | ||
+ | | Charles Hamelin | ||
+ | \\ | ||
+ | **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:** | ||
+ | |||
+ | ^Gold medalist | ||
+ | | Dara Howell | ||
+ | | Justine Dufour-Lapointe | ||
+ | | Kaillie Humphries | ||
+ | | Alex Bilodeau | ||
+ | | Heather Moyse |P.E.I. | ||
+ | | 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