Hello!
I am deleting some blank rows from my data, I am using the 'Alter Row' function to after which I am running a isNull(COLUMNNAME) to get rid of the data.
It is appearing fine in the Alter Row box during the data preview, however after I try to sink the data into a CSV - I am still getting all the columns that are being deleted beforehand? Not sure what I am doing wrong here, would appreciate any tips.
Here are the screenshots:
This is the data preview of my Alter Row transformation. After is the data preview of my Sink transformation, as I can see all the rows that are supposed to be deleted, or have the red 'X' next to them, are still featured during the sink.
