Rename the Field name dynamically

[Kaustubh17]

Hi Team,

I have data in the below format i am sharing the field name 

Serial Number

Category

Unit

2022-04-01

5/1/2022

and So on till date

I want to make the field name changes to Apr-22, May-22 and So on. Whenever the new file added the field name dynamically changes to  MMM-YY format.

Please let me know if you have any questions.

Thanks

Kaustubh

[Qiu]

@Kaustubh17 
We can use the Dynamic Rename tool to first parse the target field to DateTime value then change them to your desired format.
but the sample will need  further modification if you have more types of format.

This is a weekly challenge can be good reference.
https://community.alteryx.com/t5/Weekly-Challenges/Challenge-414-Mastering-Date-Formats/td-p/1242461

[Kaustubh17]

Hi @Qiu 

I want to highlight one think the column name which have date are in string formate.Does the below query will work for the same

Thanks,

Kaustubh

[Qiu]

I think it will work.