Hi @ally! There are a few things you can do. You can use the Levenshtein distance expression in an advanced join to match on columns that are “close” to each other.
You can also use the use LLM node and ask the model (eg. GPT4o) to output the closest match for a particular column value. You can read more about the node here: https://www.palantir.com/docs/foundry/pipeline-builder/pipeline-builder-llm
Let me know if this is what you’re looking for or if you have any follow up questions!