switch case inside of callulated field

Byron Burton shared this question 5 months ago
Completed

I need to change the case inside of a calculated field so I can compare it to another field.

Is this possible?

Replies (18)

photo
1

I have 2 fields, one is in lowercase and one is in uppercase. I tried using the case conversion in the menu but it is not making the comparsion.

Name is in upper case

Vendor is in lowercase

I need to compare the Name field to the Vendor field

How can I do this?

photo
1

Hello Byron Burton

Thank you for submitting this request to the Yellowfin Technical Support Team. My name is Sharwari Inkane and I will be supporting you with this issue.

Allow me some time to look into this issue. I will get back to you with my findings shortly.

Sincerely,

Sharwari Inkane
Yellowfin Technical Support

photo
1

Hello Byron Burton,

To change the case inside of a calculated field, you can utilize the formula type as "Freehand SQL". Within this, you can use the "Lower" Keyword before the field name. For ex. Lower(Name), this will convert the text in the "Name" field to lowercase. Please check the below screen recording for your reference:

https://ftp.yellowfin.bi/f/3954e8332429e3c2

Please review this and let me know if it resolves your query.

Regards,
Sharwari Inkane

photo
1

Didn’t work.  See the screens


CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.


New Comment






switch case inside of callulated field [community.yellowfinbi.com]




Sharwari Inkane [community.yellowfinbi.com]

Hello Byron Burton,
To change the case inside of a calculated field, you can utilize the formula type as "Freehand SQL". Within this, you can use the "Lower" Keyword before the field name. For ex. Lower(Name), this will convert the text in the "Name" field to lowercase. Please check the below screen recording for your reference:
https://ftp.yellowfin.bi/f/3954e8332429e3c2 [ftp.yellowfin.bi]
Please review this and let me know if it resolves your query.
Regards,
Sharwari Inkane

OPEN COMMENT IN BROWSER [community.yellowfinbi.com]


Stop receiving notifications [community.yellowfinbi.com] about this question
photo
1

Didn’t work


CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.


Status → In Progress




switch case inside of callulated field [community.yellowfinbi.com]

I need to change the case inside of a calculated field so I can compare it to another field.

Is this possible?

OPEN question IN BROWSER [community.yellowfinbi.com]


Previous Value: Awaiting Reply
Updated by: System [community.yellowfinbi.com]


Stop receiving notifications [community.yellowfinbi.com] about this question
photo
1

Hello Byron Burton,

Please do not include spaces in the fields. For ex. instead of "Lower(Email Address)" , please use "Lower(EMAILADDRESS)" and then proceed. Please give this a try, and inform me of the outcome.

Regards,
Sharwari Inkane

photo
1

It did not work

I also tried exporting to SQL and trying the LOWER function there.  Did not work

I tried putting in quotes.  Did not work

I tried putting the sql that I exported into the Free hand SQL because the field names are different.  Did not work

Both did not work*** This is from the SQL

CASE WHEN Lower(sys_case_SYS_USER_ownername.name) = Lower(VW_SYS_PARTY.party_name) THEN 1 END

CASE WHEN Lower(name) = Lower(party_name) THEN 1 END


CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.


New Comment






switch case inside of callulated field [community.yellowfinbi.com]




Sharwari Inkane [community.yellowfinbi.com]

Hello Byron Burton,
Please do not include spaces in the fields. For ex. instead of "Lower(Email Address)" , please use "Lower(EMAILADDRESS)" and then proceed. Please give this a try, and inform me of the outcome.
Regards,
Sharwari Inkane

OPEN COMMENT IN BROWSER [community.yellowfinbi.com]


Stop receiving notifications [community.yellowfinbi.com] about this question
photo
1

Hello Byron Burton,

We would like to have a remote session with you to discuss further in regards to this issue based on your availability. I'm accessible from 3:30 pm to 10:30 pm IST, Monday through Friday. Please confirm your availability so we can send you an invitation.

Regards,
Sharwari Inkane

photo
1

We are communicating with our vendor.  Yellowfin is non-responsive at this point.  It wont even load.  Perhaps this is the issue.  I will let you know once it is resolved.


CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.


New Comment






switch case inside of callulated field [community.yellowfinbi.com]




Sharwari Inkane [community.yellowfinbi.com]

Hello Byron Burton,
We would like to have a remote session with you to discuss further in regards to this issue based on your availability. I'm accessible from 3:30 pm to 10:30 pm IST, Monday through Friday. Please confirm your availability so we can send you an invitation.
Regards,
Sharwari Inkane

OPEN COMMENT IN BROWSER [community.yellowfinbi.com]


Stop receiving notifications [community.yellowfinbi.com] about this question
photo
1

Hello Byron,

Sure, thank you for the update. Please keep me posted once it is resolved.

Regards,
Sharwari Inkane

photo
1

Hello Byron,

I hope you are doing well. I wanted to followup regarding the non-responsiveness of Yellowfin. Could you please confirm if the issue has been resolved, or if there are any updates on this?

Please keep me posted on any updates.

Regards,
Sharwari Inkane

photo
1

Vendor still looking at it.  Will restart server


CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.


New Comment






switch case inside of callulated field [community.yellowfinbi.com]




Sharwari Inkane [community.yellowfinbi.com]

Hello Byron,
I hope you are doing well. I wanted to followup regarding the non-responsiveness of Yellowfin. Could you please confirm if the issue has been resolved, or if there are any updates on this?
Please keep me posted on any updates.
Regards,
Sharwari Inkane

OPEN COMMENT IN BROWSER [community.yellowfinbi.com]


Stop receiving notifications [community.yellowfinbi.com] about this question
photo
1

Hello Byron,

Thanks for the update. Please keep me informed of any updates and let me know once the issue is resolved.

Regards,
Sharwari Inkane

photo
1

Hello Byron,

Do we have any updates on this?

Regards,
Sharwari Inkane

photo
1

Hello Byron Burton

I wanted to follow up with you regarding the non-responsiveness of Yellowfin. Could you please confirm if the issue has been resolved, or if there are any updates on this?

If you are unavailable right now, you can always contact us again at a later time by opening a new ticket I will close this case by the end of business tomorrow if I do not receive a reply.

Please let us know if you need additional support on this issue.

Thank you,

Sharwari Inkane

Yellowfin Technical Support

photo
1

Hello Byron Burton,

I hope all is well,

Just wanted to let you know I'll be closing this request due to inactivity. However, you can always contact us again at a later time by opening a new ticket, we will be more than happy to help you.

Regards,
Sharwari Inkane

photo
1

Understood. The company wants to move in a different direction.


photo
1

NEW QUESTION. Is there a way to count how many times a special character occurs within a field. Here is the example. How many times does the pipe character "|" occur within a field?. This is what the current data looks like.

1Z4YA257A894177584|1Z4YA257A895082880|1Z4YA257A897098922|1Z5F01400390393702|1ZA446T99018974379|1Z97747E0325947118|1ZA446T99018958002|1ZA446T99018942902|1Z0080740310407198|1Z0080740333340645|1Z0080740333340690|1Z0080740366673868|1Z03E65E0166711278|1Z03E65E0366711381|1Z03E65EYW08543585|1Z03E65EYW08543692|1Z03E65EYW08543754|1Z03E65EYW08543763|1Z03E65EYW08543772|1Z03E65EYW33379251|1Z6E396V0342183112







Leave a Comment
 
Attach a file