Skip to main content
seth
seth
Expert ⭐️
October 13, 2017
Solved

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

  • October 13, 2017
  • 4 replies
  • 64 views
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.
    Best answer by sai_ram
    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

    4 replies

    jitin_mehndiratta
    jitin_mehndiratta
    Helper ⭐️⭐️⭐️
    October 17, 2017
    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
      seth
      sethAuthor
      Expert ⭐️
      October 17, 2017
      Thank you, Jitin. So it sounds like, right now, it will be case-sensitive?
      AI Transformation @ Gainsight
      sai_ram
      sai_ramAnswer
      Expert ⭐️⭐️
      November 30, 2017
      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
      seth
      sethAuthor
      Expert ⭐️
      November 30, 2017
      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.
      AI Transformation @ Gainsight
      Terms & ConditionsAccessibility statement