This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I face a problem with Select in my workflow. I change the type of column in Select from date to string, and then compare it with other string.
However, once I finish the chain of apps and rerun the my apps, it returns in a error than I can only compare string field. When I open the workflow itself, Select has type as String, BUT after I run it as a workflow, type changes back to Date again.
How is it possible? The idea of using Select is to change column types forever, even if the table is empty. Why does it revert my changes of type?
Select tools can be weak in this regard. I suggest a Multi Field Formula tool. Not because you need a formula for multiple fields, but because you can change apply a formula and force the type in one tool. To configure this tool, select the date field (assuming the name is consistent), change the type to string, and apply the ToString( function to that field.