You need to build a temp_test(document) with in the table results set(loop) and and map the attribute and B elements and append to orig_test (documentList) and make sure you drop the temp_test document so that it wont carry overwrite the data.When you outside of the loop finally the orig_test (documentList) should contain all kit/sku values and then create xmldata you know the service to use:
Thank you for your response but if I use the same temp document and append it. I will not get the desired result.
My requirement is to different the unique values ( here kit ) and its corresponding sku values to be appended together.
As in my example below: I want the target xml to look like this
2526303435
Not this way:
The xml looks like this [ This is when I create ]
25
26
30
34
35
Sorry, If I am not able to explain this issue properly. Is this something that can be accomplished by finding out the unique values for column1? or something that can be done usin Hash tables.
Thanks so much…LifeforWM! Infact, I have achieved it by asking the DB team to populate the second set as a comma delimited when they store the values in the view so that I can simply tokenize on webMethods.