Skip to Content
0
Former Member
Mar 12, 2010 at 02:09 PM

Graphical mapping IF then else not working

224 Views

IF C2_INPUT Exits then C2_INPUT eq C2_Output

else

C1_INPUT--JDBCLOOKUP = C2_Output

I am doing a graphical mapping and its working when C2_INPUT value is not null .If C2_INPUT value is blank then

I will take C1_INPUT and do a JDBC lookup and populate C2_OUTPUT.

we need to populate C2_OUTPUT based on C2_INPUT .

I did a Display Q and the value for C2_output is null whenever the expression fails (C2_INPUT is blank)

Here is my srcuture

INPUT ITEM OUTPUT ITEM

C1_INPUT <.> C1_OUTPUT

C2_INPUT C2_OUTPUT(graphical mapping).

I am on PI 7.0

Any thoughts are helpful and rewarded !