This is a sort of bigger question...In a previous post I posted a question about cleaning up a QuickBooks file. My question is this...
1. This happens for, let's say the October file...what is the best way to clean up the November and December files which would be very similar, assuming the user wants to see the cleaned October/November/December file..
Or do I need to clean them up individually first - and if so would the best way to be: Clean October file, save as October_cleaned, dump November file into October_cleaned, refresh and then save as November_cleaned, rinse and repeat for December. Have these 3 files in a folder and then use From Folder option to link them all up together? So the user has the 3 cleaned files but can then use the From Folder option to put them all together? Or am I missing something? Thanks. The files is a CSV file but I would probably convert to a table first...
When I looked at the From Folder tutorial, the data seemed to be pretty clean already..Thanks.
You can use a folder query, that will provide the list of files, but use the cleanup query from file that you already have as a function, it's easy to convert a query into a function. You will add a new column in the folder query, and in the formula you will call this function you created, passing file addresses as function argument.
