Skip to main content
seth
seth
Expert ⭐️
Oct 13, 2017 6:58 PM UTC
Solved

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

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.
    sai_ram
    sai_ramAnswer
    Expert ⭐️⭐️
    Nov 30, 2017 12:02 PM UTC
    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
    View in thread

    4 replies

    jitin_mehndiratta
    jitin_mehndiratta
    Helper ⭐️⭐️⭐️
    Oct 17, 2017 5:45 AM UTC
    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
    Translate
      seth
      sethAuthor
      Expert ⭐️
      Oct 17, 2017 1:42 PM UTC
      Thank you, Jitin. So it sounds like, right now, it will be case-sensitive?
      Translate
      AI Transformation @ Gainsight
      sai_ram
      sai_ramAnswer
      Expert ⭐️⭐️
      Nov 30, 2017 12:02 PM UTC
      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
      Translate
      seth
      sethAuthor
      Expert ⭐️
      Nov 30, 2017 2:06 PM UTC
      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.
      Translate
      AI Transformation @ Gainsight
      Terms & ConditionsAccessibility statement