Multi Row - Multi Field

BPetrosilli

I've been beating my head against the wall trying to come up with an easy way to create a dynamic multi-row, multi-field macro so I think an outside perspective may be needed. 

I have the following situation.

So essentially I have a hierarchy that I need to "fill down" and then concatenate across rows. Which is easy enough with a Multi-Row, Crosstab, Union iterative macro. However the problem comes in the "fill down" at the bottom, which results in the rows AFTER the lowest level "child" also filling down and the concatenation reading "j" as the end of every row thereafter. 

So 1.) A solution to this particular problem would be appreciated and 2.) A way to access the back coding of the Multi-Row tool in order to access if a Multi-Row/Multi-Field tool can be created. In other words, being able to create a formula that is able to look Row-1/Row+1 AND/OR Field-1/Field+1. 

Thanks

jarrod

See the attached example. By naming the fields in order (think x-axis) and adding a recordID (y-axis) we can transpose the data to get coordinates which allows us to reference row +-1 and field +-1. Adding a bit of logic to define which values you want to use then concatenating the results will get you what you need. 

01_Process Hierarchy List.yxmd