Skip to Content
avatar image
Former Member

How to import more than one values in single key in value mapping

I am importing the values from excel sheet using NWDS 7.5.

Successfully imported the values to integration directory part.

Assigning all the values to single KEY as shown below.

When i am testing this scenario it is displaying only DELHI for KA TN DL

Please give the solution to do this scenario..

capture.jpg (30.9 kB)
capture1.jpg (51.0 kB)
captured.jpg (36.8 kB)
capturef.jpg (39.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 28, 2017 at 10:39 AM

    pass parameters like this one below

    vm:executeMapping('<Agency>', '<Schema>', '<Value>', '<Agency>', <Xpath of the input value>"/>

    vm:executeMapping('ORG_ID', 'COUNTRY', 'CT_VAL', 'ORG_ID', /EVMSTA02/IDOC/E1EVMHDR02/COUNTRY_1"/>

    and this way you can maintain any key value using value groups :)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hii Anurag gupta,

      It is necessary to use XSLT mapping or it can be done with message mapping ??

      If XSLT is required for this, can you please provide the code because iam newer to PI/PO

  • Jan 08 at 09:35 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08 at 01:25 PM

    I think that your Issue is that you are adding all of them into the same group. Try to decouple it in multiple groups.

    Best regards,

    Ariel Bravo Ayala

    Add comment
    10|10000 characters needed characters exceeded

    • What is your concern? Cleanness? You can place them into a folder just to keep them tidy :-) Otherwise, you can create them in other than the standard namespace, then they will show up only in the cache. For doing that, you can use the Directory API.

      Best regards,

      Ariel