Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Input data with multiple format date in one column

NurulAtikah
8 - Asteroid

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)?

 

NurulAtikah_0-1603765634294.png

 

Thank you

 

11 REPLIES 11
NurulAtikah
8 - Asteroid

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

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @NurulAtikah 

 

Cheers and Happy Analyzing 😀

Labels
Top Solution Authors