Hello
I need to concatenate the values of elements <_4440_Free_text_E6> to <_4440_Free_text_E10> where <_4451_Text_subject_qualifier_E1> = COI only. The record for COI is repeated, so i think i need to merge the records somehow??? The result I'm aiming for is "Text Line 1 Text Line 2 Text Line 3 Text Line 4 Text Line 5 Text Line 6", I've tried all kinds of loops and concatenations while using the equal functoid set up so <_4451_Text_subject_qualifier_E1> = COI but I can't get it to work. I can get the result that I want but I'm getting the output duplicated, i only want to have this value generated once. I can get the output generated once but this includes the <Free text> values where the subject qualifier is AAB.
I'd appreciate any help with this as I am starting to pull my hair out now!!!
<FTX_Free_text_S6><_4451_Text_subject_qualifier_E1>AAB</_4451_Text_subject_qualifier_E1> <_4440_Free_text_E6_COMP> <_4440_Free_text_E6>Text Line 1</_4440_Free_text_E6> </_4440_Free_text_E6_COMP></FTX_Free_text_S6><FTX_Free_text_S6><_4451_Text_subject_qualifier_E1>COI</_4451_Text_subject_qualifier_E1> <_4440_Free_text_E6_COMP> <_4440_Free_text_E6>Text Line 1</_4440_Free_text_E6> <_4440_Free_text_E7>Text Line 2</_4440_Free_text_E7> <_4440_Free_text_E8>Text Line 3</_4440_Free_text_E8> <_4440_Free_text_E9>Text Line 4</_4440_Free_text_E9> <_4440_Free_text_E10>Text Line 5</_4440_Free_text_E10> </_4440_Free_text_E6_COMP></FTX_Free_text_S6><FTX_Free_text_S6><_4451_Text_subject_qualifier_E1>COI</_4451_Text_subject_qualifier_E1> <_4440_Free_text_E6_COMP> <_4440_Free_text_E6>Text Line 6</_4440_Free_text_E6> </_4440_Free_text_E6_COMP></FTX_Free_text_S6>
This is a Grouping Scenario. You can easily do it using a Scripting functoid with XSLT Script in it.
Just try this... not sure if it will work
1. Equal Functoid with input as node <_4451_Text_subject_qualifier_E1> = "COI" .
2. String concatenate functoid with all 4 nodes as input(<_4440_Free_text_E6> to <_4440_Free_text_E10> ).
3. Value Mapping Functoid with first input from the Equal Functoid and second input from String Concatenate functoid.
4. Output of this Value mapping functoid to the destination node( </_4440_Free_text_E6_COMP>).
Mail me the Project with the Schemas/Map. I will fix it for you.
Regards,NISHIL MCT,MCTS | Freelance BizTalk Consultant.biztalkconnect.blogspot.com