Hi,
I have a series of XML file and there are certain element I need to parse out.
The problem with that is those element in some file it only appear once, and in some file it could appear more than once. And when I use dynamic input try to extract it the Designer give me the error saying file have different schema.
So here is an example, let's the say the element I am trying to extract are as follows:
<Tag1>
<Tag2> 222 </Tag2>
<Tag3> 333 </Tag3>
<Tag4> 444 </Tag4>
</Tag1>
I need all the elements in side tag1, and tag1 in different file could be either appear only once or more than once, but the data inside the tag1 are all the same structure.
Therefore I thought if I just configure the child XML element to Tag1, Dynamic Input would be smart enough to extract all those elements for me.
But unfortunately, it does not, it give me the schema error, I think it require the XML file need to be exactly the same structure, and it cannot be in slightly different structure though the element I am trying to extract are the same.
I am wondering is there a work around I can use to be able extract the data using Dynamic Input.
Also, I am looking for ways in which I can dynamically parse in the child XML element name with similar pattern searching, like XML child name starts with "ABC"
i am not sure whether I should suggest this as a new feature for the next designer release.
Any help here is appreciated!