Forum Discussion
Date Time Changes from Transform Sample File Do Not Register in Main Query
I suppose that someone may have said that somewhere, but experience says otherwise. I use the transform file to make sure that each file in the folder is of the same structure, and as soon as I've done enough to have them combine correctly, I combine them and then do everything else in the main query. If you make changes to the transform file after you've already combined, you are very likely to have to then make adjustments to the main query to account for the new changes in the transform file; that's too much work!
--Nate
Oh boy! Well then, I'll re-tool my process to do all changes in the Main Query. In the Transform Query I have to do some minor transformations (Promote First Row to Headers) because I need to capture the file name (mm-yyyy.csv) so I can use it in the Main Query. Other than that, I think I can process everything else in the Main query.
