Repeating table’s column promotion/concatenation when data is from secondary source

When a repeating table has data from the Main data source, you can concatenate and promote the columns as I have already discussed in my previous blog here.

And I was with the mindset that it would work with secondary data source as well, but that was my misconception.

When a repeating table is bound using a secondary data source, then the formula to concatenate the columns of the table changes.

If we use the same old formula, the output won’t be as expected.

Continue reading