Forum Discussion

fantacola's avatar
fantacola
Regular Visitor
5 years ago
Solved

Append multiple tables but add a date column before

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 ...
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    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