Do you think that it's possible to take a value into an ODI IKM Option (for example) from a flexfield? Example: You define a flex field on the target table and then pass the value in the IKM. Then, reading the variable, it's possible to pass it to an option from the IKM?
Thanks,
After searching I found that it's not possible to do it. Conditional Expression can take predefined values. You can find in the next all the combinations:
Condition Expression – It allows you to set the required condition for the selected option. Double-click the field for editing the condition expression for the selected option. Click the browse icon Browse icon, to launch the Edit Expression Editor, which enables you to create or edit the existing groovy script that determines whether a knowledge module should be enabled, disabled, displayed or hidden.
Examples are:
return options.getValue("Cache").equals("true")?"show=true,enable=true":"show=false,enable=false";
This looks at the value of another KM Option called "Cache". If its value is "false," then the KM Option is hidden, because it's not relevant.
return (isStreaming)?"show=false,enable=false":"show=true,enable=true";
This looks at the Mapping isStreaming property. If it's true, then this option is hidden.