remove blank row from the data record

[Citizendeveloper2024]

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

[cjaneczko]

If Data cleanse isn't working you can also use the Filter tool to filter out the rows. 

[ChrisTX]

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

[Citizendeveloper2024]

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