The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Removing Null and align the data

DiyaR
8 - Asteroid

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_DateCodeGroupMaskDisc
8/14/20201B[Null]10%
8/14/20201BBXXX[Null]
8/14/20204CBSSS20%
8/14/20204CBSSS[Null]
8/14/20202ABCCC[Null]
8/14/20202ABCCC[Null]

 

Output should look like: 

Right_DateCodeGroupMaskDisc
8/14/20201BBXXX10%
8/14/20204CBSSS20%
8/14/20202ABCCC0%

 

Much appreciated! 

2 REPLIES 2
ImadZidan
12 - Quasar

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
8 - Asteroid

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

Labels
Top Solution Authors