Parabola
HomeFeaturesExamplesPricingLearn
Y

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.

Parabola
Finding the differences and similarities between two lists
Interactive Example

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.

In this example, we're going to import data from CSV files, but this procedure works with data from any of our sources.

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

Handling output

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.

Start automating with Parabola
Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.