This content has been marked as final. Show 2 replies
I don't believe there's a way to do conditional loading. Way to make this work is to load the two quantities and then decide which one to use based on formula. For instance, you could do something like
x = if(streq(lookupString(rs1,...), lookupString(rs2,...)), <use loaded value from rs1>, <use loaded value from rs2>)
What is the need to do all of these in IOP? You should do as much data manipulation as possible outside IOP --- through ETL tools or your own ETL and load the data into IOP. If for some reason, your selection is based on "calculated" value and the calculation happens in "IOP", then we have to worry about what you are saying. But thats rarely the case.