Forum Discussion
Solved
Fill blanks in column based on a condition using IF and Earlier value from another column
Hello everyone, I am trying to fill in a column with data from another column and then any blanks should be filled in with previous values from the other column too. My objective is to create a ne...
This might be easier if you do it in Query Editor. Create a conditional column and use Fill Up transformation. Also I think you misunderstood the use of EARLIER, usually it uses to access to outer row context
This might be easier if you do it in Query Editor. Create a conditional column and use Fill Up transformation. Also I think you misunderstood the use of EARLIER, usually it uses to access to outer row context
And what if the column we are using for comparison is a custom column that we created. In that scenario the column will not be visible in the column name tab.
How to deal with that situaiton.?
