Why there are null values coming up after the Cleanse function

[wmleung94]

After the Cleanse function, there are numerous of NULL items showing up from OUT, and so want to know how to avoid such NULL rows popping out. Thanks!

In

Out 

[ShankerV]

Hi @wmleung94 

Please make use of the below highlighted one to remove the null rows in Data Cleansing tool.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @wmleung94 

Please find a use case created to explain.

Kindly do the necessary modification in your workflow to get the desired output.

Input:

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[binuacs]

@wmleung94 I think after cleansing the order of your data changed, that might be the reason why you are seeing so many NULL values, Can you turn off the AMP Engine and try again?