Adding a date on a column from file name

Hello Community

Is just that i have 10 files that has the same structure so im adding them by the wildcard (*) because they are in the same folder but evry file has a date at the end of the name lets say that is named like this File_20232803 and it change for every file next file is named File_20232903, File_20233003 and so on so i need to put a column that is call date so i can put the date that the row is coming from let me put it in a table to see if i explain my self better

FileName Column 1 Date

File_20232803 Data 20232803

File_20232903 Data 20232903

File_20233003 Data 20233003

I hope i explain my self haha

Thank you so much in advance community

Have a nice day!

Developer

Developer Tools

Output

Join

Documentation

Accepted answers

@IvanMtz88 Use the output file name as field option in the input tool then extract the date using a formula tool

Date_280323.yxmd

All comments

You can use Replace() function to replace the filename with nothing. It would look something like this Replace([FileName],"File_","")

Or you can use Right([FileName],8) function to get 8 characters from the right.

You can refer to this page to learn more about string functions https://help.alteryx.com/20223/designer/string-functions

Hope this helps : )

@IvanMtz88 Use the output file name as field option in the input tool then extract the date using a formula tool

Date_280323.yxmd

Thank you so much Guys with the merge of your answers i was able to do it haha

Have a nice day guys!

Quick Links

Tags

This months top contributors

erich_shiino 280