Forum Discussion

ajsingh's avatar
ajsingh
Frequent Visitor
8 years ago

how to combile two tables based on condition

Hi All,   i was working on one scenario where i come across a condition, where i need to join two table like this
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Ohhhhh, I get it now. I was trying to read the green chicken scratch on the picture and apparently came away with the wrong impression of what you wanted. I thought you were saying that you were getting nulls and wanted the values repeated. OK, got it now, let me see what I can do.

ajsingh's avatar
ajsingh
Frequent Visitor
8 years ago

hey Greg_Deckler any lead.

    • ImkeF's avatar
      ImkeF
      Icon for Community Champion rankCommunity Champion
      8 years ago

      I would probably do it like so:

      1) Add an index-column to your left table as a key

      2) Remove duplicates on sno

      3) Merge (Left-Outer) - that will match just one row from the lookup-table

      4) Merge that back to your source-table on key (with Source on the left): So the removed dups will not get a lookup-match

      • ajsingh's avatar
        ajsingh
        Frequent Visitor
        8 years ago

        Hey ImkeF thanks for the help.

        till third step i did, but in 4th step, i am not able to understand, how to do it .

        Some screenshots would be a great help.