EXISTS clause Not working in RPD - Expression builder

Saroj Kumar Behera

Hi,

I am facing when using EXISTS clause in expression builder in RPD.

Can anybody let me know how to handle this type of expressions in Expression builder in RPD.

Thanks!!

Christian Berg -Oracle

+500 to Richard: What are you trying to achieve? Why do you have the need to write such extreme formulas in the RPD?

Never forget that whatever you write here gets interpreted row-by-row and is a very inefficient way of doing things. If you ETL your data into the correct form them this effort happens once per load instead of thousands or even millions of times for every single execution of any analysis touching that column.

RichardChan

Looks like you're combining physical and logical SQL together not sure you're able to do a subselect in the way that you have structured it there. Can you detail the logic of what you're attempting to achieve?

Nagendra Palukuri-Oracle

@Saroj Kumar Behera You can try using operator 'IN' in the column expression builder.

Saroj Kumar Behera

Thanks all for your input. I put the logic in ETL area and try to do less formulae in RPD layer. Now its working. Thanks!!