My steps look like this:
So, the repeat is on /xml/document/jobs/job
My XML viewer looks like this:
And finally my Data Model looks like this:
As I defined the repeat to start at job level I do not understand why at the Data Model level I do not have job[3] and current[1] and previous[1] instead it seems to loop over current and previous.
Unless someone else has found a way to do this, I will check with our R&D department if it is an issue or if it is my lack of understanding the XML path inner working.
Request to R&D has been opened under SHARED-89206.
Thank you both very much for your quick replies.
I do not understand why a separate extraction is necessary on job level for a field in the Data Model that does essentially nothing except making sure that the system somehow understands that there needs to be an iteration over job level instead of separate iterations over current and previous?
Perhaps my understanding of XPath and the Data Model is lacking but I am glad it works and I will apply this in my larger data model to see if it will work there too.
I see what you mean, and I have to admit that the explanation for it is a bit on the subtle side.
A detail table (or a nested detail table) needs to belong to a record, which acts as a container for fields and tables. But that record can only exists if you extract something to it, otherwise it is only considered as a hierarchical marker in the data model (as opposed to a container). In your case, since you are not extracting anything from the job level, each iteration of the repeat loop takes for granted that it is extracting content for the same unique job level.
Yeah… reading myself back, I realize my explanation may just add to the confusion, but trust me when I say that the behavior is by design. Now, whether that design was a good or bad decision is an entirely different question…
