Matching Data from Different Tables
When Merging two or more Tables, we can use the built in index type to perform different types of merging. For complete details search for the Index Type on the Pipe help page. Here will look at the following two matches:
- Exact Match: The pipe retrieves data from its cache based on an "Exact Match" lookup with the values provided.
- Near Match: The pipe will retrieve data from its cache based on a "Near Match" lookup, taking into account the numeric value provided by Maximum Number of Edits Expression which sets a tolerance for near match. For example, if the index key is "Smyhte" and the result of the index expression is "Smith" this would still be a match providing that the allowed number of edits is 3 or more because the two values are 3 changes away from one another. Specifically, substitute the 'i' for a 'y', transpose the 't' and the 'h' and insert an 'e' at the end.