nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Compare two fields in analysis

Ruthie

Summary

How to compare two fields within an analysis

Content

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

Find more posts tagged with

Comments

Ruthie

Attached is a text file with the error.

Thanks,

Ruthie

Shakher Sharma

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.

Ruthie

Ooops selected the upload image instead of Attach file. Lets try this again!

Shakher Sharma

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.