Bionic Merge Task: Is "Merge On" field case sensitive?

  • 1
  • Question
  • Updated 10 months ago
  • Answered
In a Bionic Merge Task (in an Advanced Outreach, but I imagine it would work the same for a Rule), I'm using an email address as the "Merge On" field between two data sets. Is that join going to be case-sensitive? It isn't indicated in the documentation.
Photo of Seth

Seth, Employee

  • 14,490 Points 10k badge 2x thumb

Posted 11 months ago

  • 1
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 3,254 Points 3k badge 2x thumb
Hi Seth,

We are introducing ToUpperCase() and ToLowerCase() formula functions in the transformation task of Bionic Rules for  fall release. This will help in resolving any case sensitive field comparisons including merges/joins.

Regards,
Jitin
Photo of Seth

Seth, Employee

  • 14,490 Points 10k badge 2x thumb
Thank you, Jitin. So it sounds like, right now, it will be case-sensitive?
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,416 Points 10k badge 2x thumb
Hi, Happy to inform you that this is implemented and shipped in Fall release on 28th November, 2017. 
Thanks for posting! Your feedback matters, please continue posting!
You can find more details here
Photo of Seth

Seth, Employee

  • 14,490 Points 10k badge 2x thumb
Thank you, Sai! Unfortunately I can't use them for my original use case, since that Advanced Outreach is published and therefore uneditable, but I'm thrilled about all the new Transformation functions that are available.