Rename the Field name dynamically

Question

Hi Team,

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

Serial NumberCategory Unit2022-04-015/1/2022and 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 · Answer

I think it will work.

Kaustubh17 · Answer

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 · Answer

@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

0613-Kaustubh17.yxmd