Hi Team , I am trying to remove blank rows from the data and was trying to use data cleansing option not sure if i have used the right tool please suggest
If Data cleanse isn't working you can also use the Filter tool to filter out the rows.
Data Cleanse will only filter out a row if all fields are Null (which is different from "Empty").
To ensure all Empty values are set to Null, you can use the Multi-field Formula tool with an expression like this: IF IsEmpty([_CurrentField_]) THEN Null() ELSE [_CurrentField_] ENDIF
Chris
thank you chris , for sharing :)
we tried something which is using select tool , pick up the only field that needed in the configuration > connect to data and then remove null rather using data cleansing