Hi Dundas community,
One of the developers on the team has an Excel file source that is not within his control to adjust the formatting for. Column A is made up of merged cells 5 rows down where they have the plant name. Column B and to the right has data in each row. When consuming into a data cube, this shows up as the plant name in Column A row 1, but blanks for Column A rows 2-5. He wants to be able to “fill” the plant name down for rows 2-5, but we are unable to mimic the transformation that some of the other platforms have.
We have tried to use an offset placeholder in a calculated element to say if there is a value in column A, use it, else grab the result of the row above, but you can’t refer to the element you are defining…
One alternative is to define 4 separate calculated elements and build it up for each of the 5 rows one by one, but we wanted to see if there was a more elegant way.
Picture below outlining the situation. Thanks!