Solved! Go to Solution.
Hi, Harry--
In the Transform Builder, enter Edit with formula.
You should be able to apply the formula across multiple columns. If you need to refer to the current value in the column as part of your formula, use the $col reference in your formula.
Does that help?
Cheers,
-SteveO
Don't have access to software right now, but I do know that there is no horizontal FILL function.
You could try to transpose the data and then use the vertical FILL function.
Your link is trying to open as an email address for some reason.
Cheers,
-SteveO
I have tried transposing the data, as suggested. In order to using the FILL function, it is necessary to add a column for a row count/ primary key to use within the Order clause. However New Formula: SOURCEROWNUMBER creates a column with 'No valid values' as the data is no longer in its original format and ROWNUMBER requires input for Order, which does not help.
Hi Harry,
Please have a look at this community thread, as I think it covers the situation you have encountered: https://community.trifacta.com/s/question/0D51L00005aT1EaSAK/how-can-i-fill-an-empty-value-with-the-one-from-the-previous-or-next-column
Please let us know how it goes.
Best regards,
Nathanael
Hi Harry,
The approach I was referring to in the other thread works like this: