XML. Repeat Step. Related tables

OL Connect Professional Designer
1

Hi,

I want to link two tables, or create one table inside another.

The data is in the following form, can contain one or more .

Each has one , I use Repeat Steps for this.

But each can have one or more . Separate these with Repeat Step can be extracting, but I want to merge these two tables so that the table contains the table - I mean (from the sample) if there is the first then is one entry, but if there is a second then is two entries.

Any help would be kindly appreciated

Thank you.

data

2

Just so I understand…
You want to build a detail table that would hold ItemEntry. But what would be the content of the nested table inside the detail table ItemEntry?

3

My thought was that - create detail table InvoiceItemGroup with nested table ItemEntry.
In the sample ItemEntry contents were minimized. IntemEntry contains a lot of fields. And ItemEntry count in the each InvoiceItemGroup is variable and also each InvoiceItem may contain single or multiple InvoiceItemGroup blocks.
Thats why my thought was to create nested tables for trivial data manipulation.

4

And what seems to be the problem with your creation of a nested table for ItemEntry?

Do the following step:

  1. Select your InvoiceItemGroup element.
  2. Right-click on it and select Add Repeat.
  3. Select your ItemEntry element.
  4. Go on the Steps tab of the panel that usually host tabs Settings and Steps.
  5. Right-click on the Repeat step that has been added by our previous action.
  6. Select Add Step in Repeat.
  7. Select Add repeat

As you’ll see, you now have a detail table with inside of it a nested table.

  1. Select the fields you wish to extract inside of your nested detail table.
  2. Go on the second Repeat step (usually named Repeat1 by default)
  3. Right-click and select Add Step in Repeat.
  4. Select Add extraction. Select the Extraction step you just added.
  5. Go on the Step Properties tab. You should see under the Extraction Definition panel a field named Data Table. Notice that it’s value is record.detail.

That is currently the name of the previous detail table. Since yours is a nested one, you 'll need to add the name of the nested one. Lets call it ItemEntry.

  1. Replace the record.detail value by record.detail.ItemEntry.

As you’ll notice, your now have, in your Data Model a detail table and a nested one in it.

Does that help?

5

Hi, hamelj

Thanks a lot, it helped

By utilising your idea I have put together what I was thinking, but still, there is something missing.

In the beginning I will explain what I wanted(in the attached jpg the structure is seen)

I’ve wanted to make it so that a detail table is created which contains GroupDescription, SumBeforeVat…(All Fields are seen in detail table), and then each GroupDescription contains a variable amount of ItemEntry fields(Repeat1,with with fields Description, ItemAmount and others in the image)

Structure was built successfully, but in my case data reading is incorrect:

Detail[2]->ItemEntry[1]->field Description contains text ‘PAKALPOJUMS …’

As Seen From Scfeenshot:

Detail[2]->ItemEntry[2]->field Description contains text ‘PAKALPOJUMS …’, which is incorrect, there should be an entry with text “Autentifikācijas paklpo…”. Maybe you would have an Idea why is it the way it is?

I want to accomplish this data reading, because later I will need to make a complicated( at least for me) data printing in the form of tables.

SAMPLE223
SAMPLE2231272×600 116 KB

6

To help you properly we would need to see the Template and reproduce the issue. I suggest you open a technical support ticket through our website.

7

This actually looks like a graphical bug that was fixed in version 2020.1. Essentially, the second level of nested detail data wouldn’t always show the right value in design. It worked fine once output, but it did make for some confusion while designing.

Given what you’re doing, an update to 2020.1 would be highly recommended anyway since the creation of nested detail tables have been greatly enhanced in that version.

8

I have sent a support ticket, how can I attach the Template?

9

Thank you for useful info.

10

Go back to the link I provided to open your ticket. This time enter your ticket number provided. Once in, look for an Attachment or Upload features.