Hi Team,
I am looking for a guidance to update data cleansing macro tool to be updated with one more functionality which will allow all the selected dat field to be updated in specific format , I am able to achieve the same with data time tool, however I need to insert date time tool for each column.
Hi @Avishek1 ,
If you have an idea for a new tool or improvements to an existing one, you can always submit this to the Alteryx gods in the Ideas section.
You can do so at the link below:
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas
M.
Hi @Avishek1
Instead of using one Date Time tool for every column that you want to clean, use DateTimeParse() in a multi-field tool. That way the multifield tool will be able to cover all the date columns that you want to convert.
Dan
Hey @Avishek1 !
The idea of the data cleansing tool is more to easily rid issues in the fields, not change datatypes like you need.
Actually I see the @danilang idea the best one for your case, because with multi-field you can apply to many fields at same time and even dynamically by any new text field if is the case.
Just picturing @danilang idea, should be something like this:
Just the expression to parse you will need to adapt to get your specific format. To know more about the specifiers to define your expression, you can see more here: https://help.alteryx.com/current/designer/datetime-functions
Hope that helps!