Skip to main content
kate_green
kate_green
Helper ⭐️⭐️
June 23, 2017
Question

Lookups in Day Agg Case Sensitive?

  • June 23, 2017
  • 2 replies
  • 49 views
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. 

    2 replies

    ashok_dugaputi
    ashok_dugaputi
    Helper ⭐️⭐️
    June 25, 2017
    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?
      kate_green
      kate_greenAuthor
      Helper ⭐️⭐️
      June 26, 2017
      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.
      Terms & ConditionsAccessibility statement