Forum Discussion
Error when loading from a folder
randyrettig You'll need to open your queries in Advanced Editor, copy and paste them into Notepad and search for the offending column name. It's in there somewhere.
Thanks for the reply Greg_Deckler .
I haven't altered the sample file at all. I have tried that though, and the error persists. I've even loaded one file as a sample, selected the files I want, and then turn that file into a fuction. Then I load the folder of files, and don't combine, just transform, delete all columns except file name, then add a column to invoke a function based off of the sample that I altered, and the error persists even then. Using this method I will get all 40 of the files to load, but the 10 or so that have the extra column will load as "error", and I can't pull any data out of them.
randyrettig You'll need to open your queries in Advanced Editor, copy and paste them into Notepad and search for the offending column name. It's in there somewhere.
Greg_Deckler Fowmy Thank you both for your help! Going into advanced editor and manually removing worked perfectly.