Append multiple tables but add a date column before

[fantacola]

Hi all

I want combine multiple Excel tables (growing - every month one file is added) from a folder. They have the same structure but contain no date column. I want append but somehow I need to add a date column to each table because afterward I need to identify the months. I made a date column from the file name:

I have now two columns. Of course I could expand every table and add individually a date column and append afterwards...but that's not very handy 🙂

Table (of the months) | Date of the month

table1                                   January

table2                                   February

etc.

How can I bring this all togther?

Best regads,

Daniel

[Jimmy801]

Hello @fantacola 

probably you used the automated function to combine multiple files of one file. The GUI in this case creates a function, how you your single file is read and exactly this query you have to extend and add a new column there. But the question is also, where do you get this date from? Is this the creation date or it's the month/date somehow included in your file-name? In both of this cases you need to add your date column before combining the results... and this would be exactly here...

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[fantacola]

Hello Jimmy

I see the function but my skills are too bad to make you're proposing.

The month is included in my filename.

Best regards,

Daniel

[Jimmy801 · Accepted solution]

Hello @fantacola 

then you have to add a step before your add the new custom column with the extraction of your files. Add there a new column where you use the field "name" to extract your data. After the content of your files is expanded, you will see this new column, that you created before, on every row.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy