In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases 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