***UDF or Graphical mapping

[Former Member]

Hi all,

My requirement is if there is a field TXT02 in one segment,If this field is empty then I should not populate any thing to the target ie null value,else if TXT02 exists then I need to populate constant NOTE= to the target.

Thanks,

Srinivasa

[prateek · Accepted solution]

Use "Exists" function. Then use "if". If the field exists, then map blank constant else map your required constant. No need to write UDF.

Regards,

Prateek

[Former Member · Accepted solution]

My requirement is not if TXT02 exists.if it is null then should not populate any thing else constant value.

if->exists->txt02 and Txt02!=null then constant else NOTE,Thsi is not working.

[Former Member · Accepted solution]

Hi,

You can try following mapping,

txt02 --> CollapseContext --> 
                                   Equals --> not -->
              Constant(Blank) -->
                                                      ifWithOutElse --> SplitByValue --> Target Field.
                                       Constant-->

Regards,

Rohit

[Former Member · Accepted solution]

-TXT02 equalS (Empty constant)---NOT-------\
                                                                  ifWithoutElse -------target field
                                   Constant(NOTE)---- /

Edited by: Mugdha Kulkarni on Dec 24, 2008 12:51 PM

[Former Member]

hi

try the following mapping,

if (TXT02-equals(const null))---than -

---

const(note)-- target

else -

---

TXT02-----target

regards,

navneet

[Former Member]

hi,

please make sure that ur field exist or not in case of no value. some time field not having any value (null)but that field exist.

in this case u need to use create if.

otherwise u can use exist function.

regards, navneet

[Former Member]

Hi,

You can get it with Graphical mapping,by using Exists function.

Regards,

Ramesh.