Forum Discussion
HR Data - Monthly Files
Let me lead by saying that I hope this isn't a dumb question. This is more of a conceptual "how to handle" than a specific "what's the code" type of question. I'm about to start some work where ...
hi dgkallan ,
In similar situation, i handle it like:
1) In each monthly table, add a ReportDate column, like 2023/1/1 for 2023-Jan table.
2) Append all the monthly table.
3) Do the analysis on the ReportDate column or a related date column from a dedicated calendar table.
Thank you so much. I was thinking something like this might be the answer. Do you know of a way to automatically pull the file create date into a Report Date column so that it doesn't require manual manipulation?
And I wanted to use the solution where the new file is just dropped into the same folder every month. Would that be how the append solution you suggested would work? Or is there something different that has to be done to append it?