graphical mapping issue

[Former Member]

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

[samiullah_qureshi · Accepted solution]

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.

[Former Member · Accepted solution]

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.

[Former Member]

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.

[Former Member]

Hi

For me it worked

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

Well problem is resolved

Thanks

Gaurav

[Former Member]

Hi JM

Yes you can do graphical mapping.

Do this in graphical mapping

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

Thanks

Gaurav