Removing Null and align the data

[DiyaR]

Hello Alteryx experts,

I tried multiple ways to achieve but no success... Can anyone please help. I am in last step of cleaning the null value in my Alteryx flow.. I am trying to combine 

Right_Date	Code	Group	Mask	Disc
8/14/2020	1	B	[Null]	10%
8/14/2020	1	B	BXXX	[Null]
8/14/2020	4	C	BSSS	20%
8/14/2020	4	C	BSSS	[Null]
8/14/2020	2	A	BCCC	[Null]
8/14/2020	2	A	BCCC	[Null]

Output should look like: 

Right_Date	Code	Group	Mask	Disc
8/14/2020	1	B	BXXX	10%
8/14/2020	4	C	BSSS	20%
8/14/2020	2	A	BCCC	0%

Much appreciated! 

[ImadZidan · Accepted solution]

Hello @DiyaR ,

Something like this?

I did not pay much attention about the data types. as I am not sure how you are getting the data.

This will give you an idea, I hope.

[DiyaR]

Thank you :).. It gave me an idea and it worked as expected..Much appreciated 🙂