Input data with multiple format date in one column

[NurulAtikah]

Hi everyone,

I have a question regarding input data and data type, currently, I have one column name "Date" in excel and it consists of 2 formats of data one in date and one in-text format. When I input the excel file in alteryx, alteryx detect as Date format, and date in text format become null. Is there any possible way to make the value date appear (not null)?

Thank you

[NurulAtikah]

Thank you very much @atcodedog05  and @grazitti_sapna for helping me out with this. 😀 👍

[atcodedog05]

Happy to help 🙂 @NurulAtikah 

Cheers and Happy Analyzing 😀