How to compare two fields within an analysis
How do I compare two fields in an analysis. I need "Workforce Management - Person Real Time"."Person Legislative Information"."Country" equal to "Legal Employer"."Legislation"
Thank you
Attached is a text file with the error.
Thanks,
Ruthie
Sorry, I am unable to see the text file.
Can you please go to Advanced tab of analysis and copy & paste text in SQL Issued text box? It will allow me to duplicate your analysis to debug this issue.
Ooops selected the upload image instead of Attach file. Lets try this again!
Hi Ruth,
I believe the problem is that you are not filtering last clause. For example, following line is actually a filter as it is looking for PERSON_TYPE = 300000000120758.
(DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Person Type") = 300000000120758)
Similarly, following line is a VALID filter as well as it is looking for ASSIGNMENT STATUS in (1, 4001....)
AND (DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Assignment Status") IN (1, 4001, 2001, 2))
However, the last line is not a filter. It is just a decode statement to return TRUE and FALSE. It doesn't say which value(s) you are interested in as it has no EQUAL TO or IN clause at it's end. Please look at might last image attachment. I have specifically pointed it out:
AND (CASE WHEN "- Person Real Time"."Person Legislative Information"."Country" = "- Worker Assignment Real Time"."Legal Employer"."Legislation" THEN 'True' ELSE 'False' END )
Above statement should have ='True' , or ='False' at it's end to make it a valid filter.
Please add filters one by one and test it.
UKOUG Conference Discover 2026 Three days of Apps & Tech sessions. Two days of exhibition & keynotes. One Oracle community. Join Oracle professionals, customers, partners, developers, architects and business leaders for keynotes, customer stories, technical sessions, networking and exhibition access at UKOUG Conference…
Join us this November for Oracle Analytics Cloud (OAC) Office Hours! We’ll explore recently released Data Visualization (DV), AI features and take a closer look at the Deep Insights Agent—all in one webinar, offered at two convenient times. Through demonstrations and practical examples, we’ll highlight the latest…