Mapping logic using graphical mapping.

[Former Member]

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

[Former Member]

Hi Mahesh,

Please see attached screenshot might be 100% what you are looking for but think it will help.

Standard function under Statistic - Index.

Not sure why you want to duplicate each Sub_Item.

Regards,

Jannus Botha

[Former Member]

Hi Jonnus Botha,

Thanks for  your reply,

I am not duplicate the sub_items..in input itself we will get the multiple sub_items

all fields are one to one mapping except EXIDV2 field.

it needs to populate as per the logic which i have mentioned in my post

Thanks

Mahesh

[Former Member]

Hi Mahesh,

Can you please provide me with how the source data will look like and how u will like it to be?

Then will see if it is possible?

Regards,

Jannus Botha

[Former Member]

Hi

my input will be like this:

Header

   Manifest_number

   Shipment_date

   shipment_type

   Item

     OBD_number

     package_slip_number = 9000

     no_of_packge    = 5

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

I this input we have 10 subitems (sbitem repeats 10 times)

so 10 /5(no of packges) = 2

so every two sub item will have same exdiv2 values.

in simmllar fashion if we have 15 subitems then every 3 sub item will have same exdiv2 values.

and Desired output:

Header

   Manifest_number

   Shipment_date

   shipment_type

   Item

     OBD_number

     package_slip_number=9000

     no_of_packge            = 5

     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_005

        Delivery Item Number

        Material Number

        Quantity

        UOM

[gagandeep_batra]

Hi Mahesh,

Can you provide XSd of source and Target?

and also can you explain  As u said?

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

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

means  you want  EXIDV2=2  or?

Sub_item

        EXIDV2    = 9000_001 ? how?

Regards

GB

[Former Member]

Hi Gangadeep,

thanks for your reply.

EXIDV2 = Concat (package_slip_number_0001)(0001 is constant which needs increase by 1)

10/5 = 2 this one defines how many tims the 0001,0002,0003 will repeat

so in target structure which i have give in above post

0001 repeats 2 times

0002 repeats 2 times

0003 repeats 2 times

0004 repeats 2 times

0005 repeats 2 times

thanks

Mahesh

[former_member472138]

It looks your logic have a contradiction with EXIT and number of sub items for generating.

Check the logic once again, however you can meet your requirement to certain level.

Subitem -- splitbyvalue for each - remove context - Subitem

Regards

Pothana

[Former Member]

Hi Pothana,

Thanks for your reply,

i think i need give bit more information.

my input will be like this:

Header

   Manifest_number

   Shipment_date

   shipment_type

   Item

     OBD_number

     package_slip_number = 9000

     no_of_packge    = 5

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

     Sub_item

        Delivery Item Number

        Material Number

        Quantity

        UOM

and Desired output:

Header

   Manifest_number

   Shipment_date

   shipment_type

   Item

     OBD_number

     package_slip_number=9000

     no_of_packge            = 5

     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_005

        Delivery Item Number

        Material Number

        Quantity

        UOM