Transaction - Block Types for Looping
Below is the sample excel data of a multi-line header detail transaction.
There are three types of Block Types for Header-Detail items in a loop.
- "Start Value" = Header line value
- "Loop Value" = Line item value
- "Start+Loop value" = Header + Line item value
-
Start Value
In rare cases you have a field inside the loop that should always take value from header row. In that case, you would map "Start Value" for this field inside the loop. For example, in the above data file (Fig. 1), if we do not want to write “V0” in every detail item. We can write it only once as shown in Fig. 2 & map it as Start Loop (Fig. 3). It will consider “V0” as the block type for all subsequent detail items. (Fig. 4).
Figure 3
Figure 4
-
Loop Value
In some cases, you can have Header on row 2 and all the line items will be from row 3 as shown in Fig (5). In that case, you would map only "Loop value" for the fields inside the loop. So if we assign loop value (Fig. 6) for the detail items, Process Runner will pickup the detail items from the second row below the header item.
Figure 6
-
Start + Loop Value
In some cases, you can have Header is on row 2 and all the line items will be from row 3 as shown in the following screenshot. In that case, you would map "only Loop value" for the fields inside the loop. So if we assign loop value (Fig. 6) for the detail items, Process Runner picks up the detail items from the second row below the header item.
In some cases, you can have Header is on row 2 and also line starts from row 2. In that case, you would map "Start+Loop value" for the fields inside the loop.