Most efficient way to match on partial values

(0) Share

Report

Posted on by LameImpala

I have two tables of transaction data that I am trying to merge together based on a reference column. The challenge is that the reference column in table 1 contains additional text, whereas table 2 column contains only the numeric values. I'd like to match these two columns if Table 1 contains Table 2 numeric values. My table has 89k rows and 23 columns.

The way I have done this in the past is to bring in the entire table, then select the column I want, which returns 89k rows for each row. Then I would create conditional column that does the "if contains" condition. Obviously, this is not ideal, as the data expands drastically.

Can you tell me if there is a better way to do this, potentially where I don't have to expand the table prior to me using the conditional column?

thank you