transformations:match
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:match [2018/08/15 14:21] – dmitry | transformations:match [2021/04/11 23:39] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Match ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This action goes through text values of a column in one table and finds matching values in another table (lookup table). Matched lookup values then replace original values. | + | \\ |
+ | =====Description===== | ||
+ | This action goes through text values of a column in one table and finds matching values in another table (lookup table). Matched lookup values then replace original values. | ||
- | **Match modes** | + | //Match// has 4 modes: |
+ | *Contains | ||
+ | *Starts with | ||
+ | | ||
+ | | ||
- | * // | + | \\ |
- | * //Starts with// - a lookup value is matched if the matched value starts with it. In this mode '' | + | =====Use cases===== |
- | * //Ends with// - a lookup value is matched if the matched value ends with it. In this mode '' | + | The //Fuzzy// mode of this action |
- | * //Fuzzy// - a lookup value is matched if the matched value is within the specified edit distance. The [[https:// | + | |
- | ===See also=== | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the column in the current dataset that contains the values to match in the lookup table.| | ||
+ | |Lookup table|Select the dataset to be use for the lookup.| | ||
+ | |Lookup column|This setting appears once the //Lookup table// has been selected. | ||
+ | |Match mode|Options: | ||
+ | |Case sensitive match|When checked, text case must match in the lookup values.| | ||
+ | |If not matched|Choose how unmatched values are handled. | ||
+ | \\ | ||
+ | ====Match mode settings==== | ||
+ | ^Mode^Description^ | ||
+ | |Contains|A lookup value is returned if the source value contains it. For example, " | ||
+ | |Starts with|A lookup value is returned if the source value starts with it. For example, " | ||
+ | |Ends with|A lookup value is returned if the source value ends with it. For example, " | ||
+ | |Fuzzy|A lookup value is returned if the source value is within the specified //edit distance// | ||
+ | |Max. edit distance|This setting appears when the //Match mode// is set to " | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | \\ | ||
+ | **Table 1:** Source value | ||
+ | ^Source text^ | ||
+ | |Motorola| | ||
+ | |||
+ | **Table 2:** Lookup table | ||
+ | ^Lookup values^ | ||
+ | |tor| | ||
+ | |Moto| | ||
+ | |rola| | ||
+ | |Motrola| | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | >Column is " | ||
+ | >Lookup table is "Table 2" | ||
+ | >Lookup column is " | ||
+ | >Case sensitive is unchecked. | ||
+ | >If not matched, "Make empty" | ||
+ | |||
+ | \\ | ||
+ | Using the two tables and parameters above, the following tables show the results of the given settings.\\ | ||
+ | \\ | ||
+ | > | ||
+ | |||
+ | ^Source value^ | ||
+ | |tor| | ||
+ | \\ | ||
+ | > | ||
+ | |||
+ | ^Source value^ | ||
+ | |Moto| | ||
+ | \\ | ||
+ | >**Ends with** match mode: | ||
+ | |||
+ | ^Source value^ | ||
+ | |rola| | ||
+ | \\ | ||
+ | > | ||
+ | |||
+ | ^Source value^ | ||
+ | |Motrola| | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
- | * [[syntax: | + | * [[syntax: |
- | * [[syntax: | + | * [[syntax: |
- | * [[syntax: | + | * [[syntax: |
- | * [[syntax: | + | * [[syntax: |
transformations/match.txt · Last modified: 2021/07/19 02:23 by craigt