updating data cleansing tool

[Avishek1]

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.

[mceleavey]

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.

[danilang]

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 

[marcusblackhill]

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!