Below are 2 types of input xml message.
<test1> is repeating element and <AUC> is optional.
My Requirement : Need to check if <AUC> is there in the entire message or not.
i tried with SELECT statement but its not working. So at the end i used While loop.
in this <test1> and inside it <Values> are repeating.
My Requirement : I need to check if the <Name> element has AUC or not in the entire message.for this also i tried with FOR statement to iterate with <test1> and then inside i used Select statement but didnot work.
Please suggest a best way to implement the above scenario.
Thanks in Advance