Forum Discussion
How to reference previous row in the same column
The error is thrown because the 'else' clause uses the table as it exists in the previous step, but the column 'custom' doesn't exist at that step.
I think, to keep things simple, if you just use the same code but replace the 'else' part with 'else null', you can add another step afterwards and do a 'Fill Down' that should work.
It will depend on the data being correctly ordered and there being a correct 'Initial Entry' for each 'set' of data
The error is thrown because the 'else' clause uses the table as it exists in the previous step, but the column 'custom' doesn't exist at that step.
I think, to keep things simple, if you just use the same code but replace the 'else' part with 'else null', you can add another step afterwards and do a 'Fill Down' that should work.
It will depend on the data being correctly ordered and there being a correct 'Initial Entry' for each 'set' of data
Amazing, worked perfactly, thanks very much