transformations:match
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:match [2020/03/25 07:37] – 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. In case of multiple matches, an arbitrary match is taken (in no particular order), other matches are ignored. | + | \\ |
+ | =====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. In case of multiple matches, an arbitrary match is taken (in no particular order) | ||
- | **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