Date time tool to configure for multiple column

Question

Dear Expert,

I have a requirement to change the date time to a specific format for multiple column, I am able to achieve this using date time tool however I have to add every time a data time column for individual column, is there a way we can configure it to apply for multiple column.

Luke_C · Answer

@tansh0099 Can you be more specific? What's not working?

tansh0099 · Answer

Hi Luke,

it does not work when the input file is csv format. can you help me with an alternative in this scenario?

Thanks,

Tanushree

Luke_C · Answer

Hi @Avishek1

You could use a multi field formula tool and a datetimeparse function for this. See attached example.

More info on datetime functions: https://help.alteryx.com/current/designer/datetime-functions

New Workflow2.yxmd