Mapping Requirement

[Former Member]

Dear XI Experts pls help me on following mapping quiries for suitable rewards:

1. i have one field at target knot ,neeed to map this field with the source field named 'date first vessel'

condition is if date first vessel is not BLANK, Fill "010101" to KNOT

2.i have one source field container_no need to map same with target container_no

Condition is:If CONTAINER_NO has no value, populate this field with the value of BILL_OF_LADING,here BILL_OF_LADING is field name

Thanks &Regards

Shoukath

[Former Member]

Hi Shaik

You can use following -->

<i>1) If Date == "" then KNOT = "010101"</i>, you can use IfWithoutElse, stringEquals & Const functions of Graphical mapping.

2) <i>If Container_No == "" then container_No = Bill else container_No = Container_No</i> , you can use If, stringEquals & Const functions of Graphical mapping.

[Former Member]

> Dear XI Experts pls help me on following mapping

> quiries for suitable rewards:

>

> 1. i have one field at target knot ,neeed to map this

> field with the source field named 'date first

> vessel'

> condition is if date first vessel is not BLANK, Fill

> "010101" to KNOT

use the small UDF to check the contents in the input field.

UDF with one input (String) = <b>input</b> //Code...

if (input != null) {

//reutrn the input filed if it is not blank..

return input;

}

else {

return "" ;

}

KNOT -

---

(UDF) -

---

Date First Vessel

> 2.i have one source field container_no need to map

> same with target container_no

> Condition is:If CONTAINER_NO has no value, populate

> this field with the value of BILL_OF_LADING,here

> BILL_OF_LADING is field name

>

Use <b>createIf Node</b> Function

THanks

Farooq.

[Former Member]

Hi Shaik

You can do this using a UDF. Thats the simplest of the solutions

Code should be like:

if(datefirstvessel == '')

{

output = 010101;

}

else

{

output = <i><defaultvalue></i>

}

same with the other field.

If you are not sure of writing UDF's please search for some sample UDF's available in the forum.

[Former Member]

1.

use IfWithoutElse to compare with Blank

source -

---

>IfWithoutElse - Not(logical) -

---

>constant(010101)>KNOT

2.

IF (CONTAINER_NO = Blank) then BILL_OF_LADING --->target

use BILL_OF_LADING as a 2nd parameter of IfWithoulElse

[Former Member]

1. use the length function on the source node. then check if the length is greater than 0. Do this using the 'if' function and the 'greater than' function.

ie.

(if length(source) > 0 then '010101')

2.similar to 1. (if length(source) < 1 then 'BILL_OF_LADING)

nb: check that you treat a suppress as false by double clicking on the 'if' statement.