Hello there !
I’m new to the tool and I have been looking through documentation and tutorials for a while now, but I can’t find a way to achieve what I want.
It seems pretty basic to me tho, so I guess I probably missed something important in the doc.
So I have a XML file which has a common structure that I would sum up as follows :
I only know that number of
<tag_A> cannot exceed 10 within
</firstTag> and 20 within
</secondTag> , but is supposed undetermined so I proceed to loop extractions (ForEach type) and everything goes well, it’s getting stored in a detail table. No problem, I thought, that’s a clean way to work.
But the thing is, it looks like details can only be displayed as tables in the designer… and I really don’t want that, because of the various types of informations contained inside of the
<tag_A> which are to be displayed in very different places of the document, depending on their parent tag.
So, my first question would have been : How do you get the value of a field inside of a detail table ? And I found the answer in the doc : you can’t. Ok. But then, how should I proceed to just get the values anyway ?
If I try to store the result of those loops directly in the record and not within a detail table, then I don’t have a way to dynamically differenciate the
<tag_A> coming from
</firstTag> and those coming from
</secondTag> ; if I try to do the trick by creating two different fields to store them and use XPATH, I just get the “Can’t be extracted twice” error.
Is there a way to achieve this ? Also, I can’t modify the structure of the XML file, as it’s a standardized flux.
Thanks for your time, also I’m sorry for the poor XML formatting in the post I did not find how to make it cleaner than that, and for english as it’s not my native language !