Select Tool Data Types

Question

I am having trouble modifying a Select Tool to include the desired data types (see screenshot attached).

I would like field F19 and F12 to be "date" data types and field F16 to be a "double" data type but for whatever reason, these are not options in the drop down menu. I am trying to copy the configuration of another select tool I have in this workflow and have even tried to copy that one over to replace the select tool shown in the attached screenshot below however this yielded the same results. F19's data type changed from "date" to "double".

Capture.PNG

apathetichell · Answer

There's a pretty big gap from double to date. Like alteryx cannot magically turn a number to a date. It can turn a string - formatted in YYYY-mm-dd to a date - in a select tool - but that's it

if your date is something like YYYYmmdd (like 20231029) - use the date/time tool to manually configure it and create a new datefield. Or use datetimeparse([F12[,"%Y%m%d") - but you have to map it and explain to Alteryx what you want.

caltang · Answer

You can’t see it as in - the drop down doesn’t have it at all?

Or you mean it throws an error when you do change it?

Do you mind giving some sample data to work with?

P.S: I would recommend for you to change data types more appropriately with the Multi-Field Formula tool - I know the Select tool can do this too, but I would want something more controlled to be sure.