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!
Solved! Go to Solution.
@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
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 After turnoff the AMP engine try the workflow in a new window
@Cristinarangel After turnoff the AMP engine try the workflow in a new window