Data cleansing

Hello, I am having some issues with data cleansing in relation to the file attached (i.e., it is just random data). When I try to clean the data by "remove null rows" or "remove null columns" in all the selected fields, the number of records displayed increases... Does anyone know why? Thank you!

sales_stores.csv

image.png

Datasets

Common Use Cases

Help

Accepted answers

binu_acs

@Cristinarangel After turnoff the AMP engine try the workflow in a new window

All comments

Qiu

@Cristinarangel
Before Cleansing tool, you have 87526 data records, and after, it is reduced by 2 and down to 87524 data records.
So I think there is nothing wrong here? 😂

Cristinarangel

Sorry, I am very new with this tool...

That means that only two rows had null data. But what happens to the order?

Many thanks!!

image.png

Qiu

@Cristinarangel
Everyone was new to this tool at first. 😁
If you check the documentation, The Results window displays up to 1 MB of data, or up to 1,000 bytes of string data.

So in your case, most likely the order is twisted due to limitation for display, but it is actually alright on my end.
Try to place a Browse tool after the Input and Cleansing tools, then the order should be same in the Browse tool display.