Order of records changed after using Data Cleansing tool

[WuQi]

Hi Alteryx community,

I found that the order of the records changed randomly after cleaning all NULL rows with the Data Cleansing tool. Please see the attached picture for the details. I know the order should remain the same before and after the tool. Is there any setting issue here that causes the problem? Thanks very much!

[WuQi]

@BS_THE_ANALYST Thanks for the explanation. The example you gave is awesome 😁.