Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Case statement in Physical table
Is it possible to write a 'Case When' statement in 'Physical Layer' while joining tables?
Thanks in Advance.
Answers
-
Yes, open the expression builder and write it there inside (so not directly in the textarea, the "Expression" field, of the join).
0 -
Adding to Gianni: But you must do it on a fresh join. You can't change an existing "=" join to a complex join.
0 -
True: if the join is already saved as physical foreign key join first delete it. The properties window of the join clearly tell you the kind of join:
0 -
when i am trying same method getting below error message
Thanks
0 -
What *precisely* are you putting into the join condition?
0 -
You know that if you post directly everything we are not going to try to guess what you maybe try to do?
0 -
I can have this error when I try to write a CASE WHEN in a physical foreign key join. This is what Christian first said: if it's a "simple" join you must first delete it and create a new one which will be saved as complex join (with the CASE WHEN directly) and not as foreign key join.
0 -
Performance will play a factor ... if you have large row counts this case is going to be evaluated constantly and may prove problematic. So, yes, you can do it, & yes it works ... doesn't always work well.
0 -
Thank you so much Gianni Ceresa and Christian Berg . Problem solved. created a new complex join between two tables.
0
