Forum Discussion

WhatIsThis's avatar
WhatIsThis
New Contributor II
3 years ago
Solved

Join and In-Memory Lookup not working

For Join, I'm just doing a left join. Fields are both Strings. It works in Alteryx, so no idea why it's not working in Snaplogic. I also tried In-Memory Lookup but the fields are just not joining. On...
  • WhatIsThis's avatar
    WhatIsThis
    3 years ago

    It turns out that I had a Union right after the Join, and the Join wasn't the problem. I expected the union to append rows, but it doesn't work that way apparently. 

Abhishek_117's avatar
Abhishek_117
New Contributor II
3 years ago

Hi WhatIsThis 
Left and Right Path should be same, it means it will take common column from both table and join those tables on basis of that. Hope This might help you!!

WhatIsThis's avatar
WhatIsThis
New Contributor II
3 years ago

It's a common column. I checked the field format and the number of digits and there should be matches. It works in alteryx.