Changes and errors on toUpper and toLower functions

Q&A
, , , , ,
1

Hi everyone, I seem to have a strange error on the simple functions to change the case from lower to upper.
It looks like these functions have been modified and cannot be used while having a SPICE dataset, does anyone have the same issue?!

1 - "new’ function doesn’t exist on the documentation (toUpper - Amazon QuickSight)
2- Function doesn’t seem to be allowed using SPICE as a calculated field on analysis

Screenshot 2024-08-30 at 10.21.25
Screenshot 2024-08-30 at 10.21.25734×332 7.7 KB

3-function doesn’t seem to be allowed on data preparation phase

does anyone have the same?

2

3-function doesn’t seem to be allowed on data preparation phase

Screenshot 2024-08-30 at 10.24.38
Screenshot 2024-08-30 at 10.24.38788×322 10.8 KB

3

Hi

You can use these functions for direct query I believe.

4

Indeed, but given the size of the dataset and how is built, it wouldn’t perform properly…

5

Hi

Yes, that’s the constraint.

6

Hi @rodrigolodi,
It’s been awhile since we last heard from you; checking in to see if you had any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

7

Hey Brett,

Thanks but I don’t really have an answer here as documentation remains outdated (function is not even the same anymore), so I’m still unsure on why this has changed for SPICE data and what are the possibilities for a workaround.

Let me know please if there’s anything you can share!

Thanks,

8

Hi @rodrigolodi,
What does the string look like that you’re trying to change? Is it always one word (with a single character that needs to be capitalized or lowecased) or multiple word?
Depending on what your string looks like, there could be a potential work around.

But additionally, are you able to complete in SQL? That would definitely be the easiest option.

9

Hi @rodrigolodi,
It’s been awhile since we last heard from you; did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

10

Hi @rodrigolodi,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!