This content has been marked as final. Show 3 replies
Let's say we are mapping from APP View to Common View. And let's say we have a DVM called "UOM_DVM".
In the mappings screen, on the Left hand side (Application View),
1. Select the Source (Test) Field that you are going to test.
2. Now (keeping the "Ctrl" key pressed) select the Source (Data) Field that you are going to use the DVM transform on if the test is satisfied.
From Transformations, select "TrueConditionalLookupDVM".
Now, on the right hand side (Common View), select the Target (Data) Field.
Press Apply, and this brings up the "Mapping" screen.
In "condition" put the value (string) that you want to test for from the Source (Test) Field. e.g. without quotes "TestValue"
In "table" select your DVM (e.g. UOM_DVM)
In "pass through" choose 'true' or 'false', depending on your requirements.
APPLIC View............................Common View
SOURCE_DATA .......................... TARGET_DATA
The mapping would be something like >>>
Hope this helps you.
Thanks Yan. THat should work. Now I remember doing something similar a while back.
No worries! :-)