Latest News

the latest news from our team

How to repeat a node value in eFORMz

Traditionally, data filtering or data filtration involves analyzing, editing or manipulating a smaller part of a data set. In the context of eFORMz, data filtering refers to sifting through a data file or multiple data files to retrieve a subset of the file, analyze it and then make a decision, usually to include that subset in another form or label, to use that subset as criteria for conditional processing, to repeat the subset or to exclude the subset. Repeating a node value is one of the many advanced data filtration methods eFORMz can use.

Sample

In this example, the label-set is created as a group and should include one <Header_label>, multiple <Detail_labels>, and one <Footer_label>. The <Detail_label> has a requirement to be created as a single, separate label. In other words, each instance of a detail line should be its own label. So, in this example, a query returned three detail lines, but each with multiple quantities:

ROW_COUNTShoeNameLocationQTY
1ShoeAAAA2
2ShoeBBBB3
3ShoeCCCC2

What happens if you want to create extra labels for the quantities of the detail lines? Put differently, instead of creating three separate labels for three detail lines, how could you create separate labels based on the quantity? You’ll have to split the data based on the quantity. What does this look like? Essentially, you create a list of commas based on the quantity. You then replace the commas with the row-specific data. Next, concatenate the list into one string. Finally, split the string based off of the comma.

A sample project is available here: DataNodeRepeat.zip

Leave a Reply

Your email address will not be published. Required fields are marked *