Data cleansing

[Cristinarangel]

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!

[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!! 

[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.

[Cristinarangel]

Many thanks for your help, but unfortunately it still does not display the order correctly. 

I even tried to increase the Memory Limit Anchor... 

Not sure what I am doing wrong. 

[binuacs]

@Cristinarangel Run the workflow after turnoff the AMP engine

[Cristinarangel]

Thank you Binuacs, but it did not do the trick. It is very strange.

I turned it off, i run it and still the same problem...

[binuacs]

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

[Cristinarangel]

Sure. 

[binuacs · Accepted solution]

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