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