Filtering for a subset of data from a single table

[mlauber71]

@mvaldes you can do something like this.

The key will be to identify a start (and stop) line and assign your ID or Rownumber to it and if necessary fill the lines in between with the help of the missing value node.

Replace placeholder with values from above?

@Tim8200 you can also do the replacement only for a specific column @HansS nice solution with the implicit creation of a missing value in the Rule Engine [image]

Here is a somewhat similar example.

Loop on the basis of single Excel sheet data

OK it was slightly more complicated than I initially thought. But I hope it does work now: give each line a unique ID to identify them later identify the ‘heads’ of the tables (“FORMNAME”) like you already did use moving aggregate to give the heads unique numbers bring these numbers back to the data fill the intermediate (empty) cells with the head’s number use a group loop on the blocks identified by the head numbers extract the first line as column names make sure empty columns that would ju…

Or maybe you upload your excel file here (deleting sensitive information first) and we could try a few things.