A hint to get me started?

I have been trying to figure out how to approach this transformation using the tool. I haven’t been able to figure out how to get started.

The extracted data has two columns, number and title. This database extract has grouped records by owner.

The first row is the header.
In the second row is the number field contains the name of the owner, the title filed is blank.
What follows then is rows with the number and title of their policies until a new ‘owner name’ shows up.

I have been trying various gather and filter blocks to append the owner to the start of the rows they own. But I can’t figure out the combination of blocks to make it work.

I was wondering if you would give me a tip to get going?

The final set of columns is Owner, Number, Title

There is probably more than one way to do it, but the attached works. Basically use an If to create a new column then fill down. Then finish with some filtering and reordering.

sample.transform (2.1 KB)

1 Like