Forum Discussion

ianbruckner's avatar
ianbruckner
Frequent Visitor
4 years ago
Solved

Merging with one exact match column and one fuzzy join column

Is it possitble to do a merge based on two columns... one that requires the first column selected to be an exact match, and on a second column with fuzzy join settings applied?   I'm trying to merg...
Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    Hi ianbruckner ,
    I'm afraid, but the merge/join-condition can only be set on the join level and not on column-level.

     

    For inner joins, you can simply do them one after another, but for outer joins you have to expand the matched columns and then apply some logic afterwards (taking only those rows, where both expansions returned values).

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
4 years ago

Hi ianbruckner ,
I'm afraid, but the merge/join-condition can only be set on the join level and not on column-level.

 

For inner joins, you can simply do them one after another, but for outer joins you have to expand the matched columns and then apply some logic afterwards (taking only those rows, where both expansions returned values).

ianbruckner's avatar
ianbruckner
Frequent Visitor
4 years ago

Thanks, ImkeF. Your answer of possible or not was helpful... and your solution of double merging is leading me to consider my datasets more closely to see if there might be other similarties I can code against.