Lookups in Day Agg Case Sensitive?
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.
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?
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?
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.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.