Hi Experts,
Can any one please help me on below requirement.
In my oracle query I have the inner join statement like below. How to replicate this join in Qlik.
inner join risk_factor rf on r.metricid in (rf.firstid , rf.secondid)
Means on r table and rf tables need to apply inner join
but from r table need to consider metricid field
from rf table need to consider two ids like firstid and secondid two fields.
How to apply inner join on Qlik with two ids from second table.
Thanks in advance.
