Solved
Merge two tables based on multiple criteria
Hi there,
I’ve been trying to find a solution for our use case with no success, so I’d like to ask the Community for help.
We have two tables (both from Salesforce), table A contains deal informa...
Hi @JanosIT
One of the possible solutions could be:
-
Concatenate Client1 and Client2 fields and use them as a key while joining
-
Use Filter Snap to implement the rest of the criteria
-Start Date (B) is equal or greater than Start Date (A) -End Date (B) is equal or less than End Date (A) -Area Code (A) contains Area Code (B)
Regards,
Spiro Taleski-
