Skip to main content
Solved

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

  • October 13, 2017
  • 4 replies
  • 30 views
seth
Forum|alt.badge.img+9
  • seth
  • Gainsight Employee ⭐️⭐️⭐️
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
AI Transformation @ Gainsight
seth

4 replies

jitin_mehndiratta
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
seth
Forum|alt.badge.img+9
  • seth
  • Author
  • Gainsight Employee ⭐️⭐️⭐️
  • October 17, 2017
Thank you, Jitin. So it sounds like, right now, it will be case-sensitive?
AI Transformation @ Gainsight
sai_ram
Forum|alt.badge.img+1
  • sai_ram
  • Expert ⭐️⭐️
  • Answer
  • 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
Forum|alt.badge.img+9
  • seth
  • Author
  • Gainsight Employee ⭐️⭐️⭐️
  • 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 & ConditionsCookie settingsAccessibility statement