Finding the differences and similarities between two lists
Take two lists, find which rows exist in one list, but not the other. Or, find which rows exist in both. Useful for removing duplicates across lists, or finding new entires in a list.
One of these things is not like the other
Sometimes you just need to know: which of these things is not like the other?
This example is short and sweet (but useful!): we've got two lists of data containing ids, phone numbers, and emails. We want to find the entries that appear in both lists, and the entries that appear in one list but not the other.
The power of "list contains"
The main logic in this flow comes from Parabola's list contains step. That step takes as input two lists, and outputs entries that match the conditions specified in its settings panel. By default the step will output entries that appear in both input lists, but settings allow lots of flexibility:
- You can add arbitrarily many rules, i.e., match items along multiple conditions
- The step can output items that do not match any or all of your rules
- The step can be configured to be case sensitive or case insensitive
- You can use fuzzy matching as part of rules, and can optionally configure the fuzziness as a percentage.
- (For debugging) the step can be configured to output a column indicating how a match was achieved
In this example, once we've identified the matching entries we simply export them as a CSV file. But again, you can export your results to a any of our destinations, or continue working with them in Parabola as part of a larger flow.