Capture Dynamic Lines record for detail

OL Connect Professional DataMapper
1

Hi, would like to get some help on extract dynamic lines records which i cant able to extract a set of record.

image
image1366×768 141 KB

Here is my flow

image
image1355×707 95.9 KB

Please advise.

Thanks in advance

2

Hi Desmond, can you provide us with a bit more detail on what you are wanting to extract? Do you want to define a variable number of lines for extraction, or do you want to set up a variable extraction area?

3

Hi Justin,

I would like to capture the detail table in my invoice. This invoice consist of 7 column with 2 row records.

My issue was in the Invoice Description column. It contain multiple lines of values. Refer to yellow box.

image
image1035×507 21.5 KB

Can guide me how to extract it?

Regards
Desmond Kuan

4

Obviously, you will need two Repeat.
First one goes through all your items of your invoice. Once in that Repeat, you will extract all the information of the first line of the items but for the description first line, you will Set your field Data Table to Record.detail.desciptionLines. This will create a new nested detail table named descriptionLines.

In the second Repeat, you will loop through all lines of your Description while you find nothing under the column No. That will mark the end of the Description column.

5

Thanks for recommendation. I got it

6

How was this detail table structure displayed, on the template? I have a similar need: a “multi-line” description field that wraps onto a variable number of lines under the parent line item record.

When I display the line items within a dynamic table, I need to display the description field, which will be all the fields in the record.detail.descriptions table.

7

Hi @TDGreer,

Can you please share a (anonymized) screenshot of the record lines and record detail lines which you would like to extract?