How to map so that target node is not created if the source value is blank?

[gopalkrishna_baliga]

Hi Experts,

I have to map Qty field from source to Stock element of target XML.

Now if Qty value is 0 it is still generating the target Stock element which is empty (</Stock>). What I need is that if Qty is 0 then <Stock> element should not be generated at all. I am uisng graphical mapping.

How to achieve this? kindly help

Thanks

Gopal

[Former Member]

Hi,

In case you are using an UDF, you could use, resultnode.suppress().

This would suppress the creation of the target node and all the subelements under it.

Regards,

Smitha.

[gopalkrishna_baliga]

I have written a UDF and output of this I am splitting by value (SplitByValue).

GetQnty(UDF) ->SplitByValue ->Stock

So how do I change my mapping so that stock is not created for Qnty = 0.

Kindly help

Thanks

Gopal

[gopalkrishna_baliga]

Can I map it like this?

GetQnty(UDF) ->SplitByValue ->

not equals -> Createif ->Stock

Constant[] -

---

>

Please help!

Thanks

Gopal

[Former Member]

In your UDF, check for the quantity value and then use a if condition to check if it is equal to zero. If it is equal then use resultnode.supress with in the code.

Regards,

Jai Shankar

[prabhu_s2]

i hope SplitByValue might be req in this case. just map the source and target node theu the udf and test the mapping in MM or in IM. This will get you the result.

[Former Member]

Gopal,

Are you using a simple UDF or an advanced UDF?

You need a advanced UDF to achieve this....

Your code for the advanced UDF should be some thing like this...

int res = Integer.parseInt(a[0]);

if (res==0)

{

result.addSuppress();

}

else

{

//write the logic here

}

Regards,

Jai Shankar

[Former Member]

Hi,

If you are using the message mapping, then use createif

qty--if greater than 0 then -- createif -- target node.

here you can check the exist also .but..

if you are using any UDF then you can suppress the value to it if it is 0.

Regards..

Chilla..