Merge on the basis on 'contains' operator

Hi @garg.kartik789 

I have needed this as well, and have come to the conclusion that it’s not possible. I have logged an idea that would allows us to achieve this, and which you may want to upvote:

My idea was to be able to merge on “OR” conditions, which I believe this would work for your use case too (if implemented). 

In the meantime, to achieve what you want, I believe you could perhaps pivot your data (it looks like a multi-select picklist) to turn the V1,V2 etc. into columns. That will give you integer values for each column, probably 0 and 1. You could then merge on column value (with your other data set to which you would have applied the same kind of transformation) or transform them into a true or false or else, and merge on the basis of that transform. 

I haven’t tested this, but that’s a possible route to follow. 

Let me know what you think/if it works out for you. 

Thanks!

A

I would think a Case Expression can achieve what you need by doing your “contains” logic there and spitting out the two values you’re wanting to merge.