You’re offline. This is a read only version of the page.
2
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
Share
Report
All responses (
Answers (
