I have a column that is something like this
| A | B |
|---|---|
| Value1 | Some Value |
| null | Some Value |
| null | Some Value |
| Value2 | Some Value |
| Value3 | Some Value |
| null | Some Value |
| null | Some Value |
and i want
| A | B |
|---|---|
| Value1 | Some Value |
| Value1 | Some Value |
| Value1 | Some Value |
| Value2 | Some Value |
| Value3 | Some Value |
| Value3 | Some Value |
| Value3 | Some Value |
i have used tjava_row but have encountered certain error. i have used the code given below, or should i go for python(ffill) or pyspark for designing the elt job:
if (row2.A==null) {
row2.A = row1.A
} else {
row2.A=row2.A;
