Skip to Content
author's profile photo Former Member
Former Member

graphical mapping issue

Hi All,

I am trying to achieve the following using the graphical mapping tool.

Source:

Document..... 1-1

.....rows........ 0-unbounded

.........field1.....1-1

.........field2.....1-1

Target:

Document.....1..1

..... header ....0-unbounded

......lines........0-unbounded

In the target structure, I want to create a lines for every rows in the source structure, but also, if field 1 > 0 AND field 2 > 0 in a row in the source structure, then these need to represent two separate lines.

Can I achieve this in the graphical mapping tool? If not, I will have to do it in xslt. Please help!

Regards,

JM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 11, 2008 at 04:02 AM

    Hi,

    Yes, you can implement it using graphical mapping. You have to do following:-

    1. You have to map 1..1 map with rows and line.

    2. Now duplicate the line node. Map it as following

    Check Field1 and Field2 is greater than 0 using arithmetic function greater. AND output of both the comaprion using boolean function AND and give its output to createIf and map it to line.

    Regards,

    Sami.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      2. Now duplicate the line node. Map it as following
      Check Field1 and Field2 is greater than 0 using arithmetic function greater. AND output of both the comaprion using boolean function AND and give its output to createIf and map it to line.

      After Creatif , you need to use CollapseContext.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 04:13 AM

    Hi JM

    Yes you can do graphical mapping.

    Do this in graphical mapping

    http://www.flickr.com/photos/32274480@N06/3021401846/

    Thanks

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 06:47 AM

    Thanks Sami. That has fixed my problem and I did not have to use collapsecontexts. Points awarded.

    Gurav, I also tried your suggestion but that did not work. As mentioned, I need to create one Line for every rows also. therefore if I got 3 rows, I need 3 lines. If one of the rows has both field 1 and field 2 greater than 0, then I needed 4 lines. Your suggestion only created one 1 row.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.