Bad selection in nested tables

OL Connect Professional DataMapper
1

https://learn.objectiflune.com/qa-blobs/4105865510794556591.ol-datamapper

Hello,

I need to extract several nested tables in an XLM file.

When I select a table inside another table, all the same tables in the other elements from the first table are selected.

The example shows the table Clausulas inside the table PolicyItems, in this extraction the clausulas from the PolicyItems[1] are joined to the Clausulas from PolicyItems[2]

How can I solve the problem?

2

Your configuration is extracting all clauses to the Clausulas detail table, regardless of who their parent is. If you want to know which Clauses belong to which policyItem, you will have to extract one of the unique policyItems fields inside the detail table (for instance, the vehiclePlate field). This way, you will know that any Clausula record with a vehiclePlate of xxxx belongs to the policyItem with the same plate number of xxxx.

3

Thank you Phil.

There is a way to extract into the clausulas’s table only the clauses of each policyItems?

Claudio

4

Yes. In your Extracción step, set the Data Table to record.Items.Clausulas. This will automatically set each Clausulas detail table under its parent policyItem.

5

Thank you Phil, it’s work fine.

Claudio

6

Hello, Phil

I can not access from the design tool to nested tables, only tables in the root level are available to create a dynamic table.

Claudio