So I have this data sources that are generated on a monthly basis by the system and before I appended all these together, I need to differentiate them by months for analysis purposes. The problem is, the only way to identify the month this report is by their filename. In the past, I've manually added this identifier to the file one by one by appending a new column within each database and specify month of analysis in the equation editor, which I found to be tedious. So I'm now thinking of uploading all of them using the upload multiple file script and add this appending function into the script. However, I can't seem to get the equation right for the life of me. I realized this might be because the database name is at different level than the data and hence I can't call the database name in the field equation. Is there a workaround to this?
Last seen: 3 years 1 month ago
Joined: 12/12/2017 - 02:19