Skip to Content
0
Former Member
Jun 10, 2014 at 06:31 AM

Mapping logic using graphical mapping.

14 Views

Hi Experts ,

I have a mapping requirement where we need to create the target structure like the below

source structure:

Header

Manifest_number

Shipment_date

shipment_type

Item

OBD_number

package_slip_number

no_of_packge

Sub_item

Delivery Item Number

Material Number

Quantity

UOM

Target structure:

Header

Manifest_number

Shipment_date

shipment_type

Item

OBD_number

package_slip_number

no_of_packge

Sub_item

EXIDV2

Delivery Item Number

Material Number

Quantity

UOM

Almost all mapping is one to one except for the field EXIDV2

here we need to use the below logic

need to count the no of sub items in source structure.

then we need divide that value with no_of_package value.

based on the result value we need to provide EXIDV2 values.

EX: suppose no of package = 5

no of sub items = 10(this value we need to get based on how many times the sub item repeating in source structure.

then 10/5 = 2

so i want target structure like this:

Header

Manifest_number

Shipment_date

shipment_type

Item

OBD_number

package_slip_number=9000

no_of_packge

Sub_item

EXIDV2 = 9000_001

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_001

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_002

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_002

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_003

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_003

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_004

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_004

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_005

Delivery Item Number

Material Number

Quantity

UOM

Sub_item

EXIDV2 = 9000_006

Delivery Item Number

Material Number

Quantity

UOM

Please help to get this logic.

thanks in advance

mahesh