Forum Discussion
Append multiple tables but add a date column before
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
Community ChampionHello 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
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
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
