Lookups in Day Agg Case Sensitive?

  • 1
  • Question
  • Updated 12 months ago
  • Answered
We are currently using a Day Agg function to lookup a value in our portal object on SFDC and match that value to the account name.  Are the lookups involved in this function case sensitive?  I'm finding a lot of the results are being returned as -999 "Account Not Found" even though they do match on everything except for the letter case. 
Photo of Kate Green

Kate Green, Champion

  • 4,368 Points 4k badge 2x thumb

Posted 12 months ago

  • 1
Photo of Ashok Dugaputi

Ashok Dugaputi, Employee

  • 1,490 Points 1k badge 2x thumb
Hi,

What is the source of the data here? Currently it is a limitation within the product of not having ability to convert the case. It not only impacts the joining but also the counts (count of upper case and lower case value separately) when aggregated.

Is there any reason joining taking place of Account name, which is usually not a recommended one?
Photo of Kate Green

Kate Green, Champion

  • 4,368 Points 4k badge 2x thumb
Thanks Ashok - I thought that might be the case.  The source of the data does not include the Account ID and so I need to use the client's portal name to join, as opposed to Account ID.