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

Hi @NurulAtikah

Here is a formula for the task.

IF !IsEmpty(DateTimeParse([Date],"%d/%m/%y")) 
THEN DateTimeParse([Date],"%d/%m/%y") 
ELSEIF !IsEmpty(DateTimeParse([Date],"%d-%b-%y"))  
THEN DateTimeParse([Date],"%d-%b-%y") 
ELSE Null() ENDIF

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀 👍

Hi @NurulAtikah . can you share your input file, so that I can test it? One thing I can think of to solve this issue is to convert your date field into string using select tool.

I believe you will be able to read all the data then after that you can apply formula tool and convert the dates into alteryx format and change the data type into date by copying the values into another column or can replace the datatype of the same column using select tool. I hope this will help you.

Thanks.

Hi @NurulAtikah

Kudos i was able to find a workaround.

While reading the file from input tool set first row has data like below Input tool config. Then it will take column as a string.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀 👍