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.
randyrettig So, best guess on this is that in your sample file you have proof.proof_email_array_add and likely have a step to remove that column. What you need to do is to change that step to instead of removing the column, select the columns you want and remove other columns. So a Table.SelectColumns versus a Table.RemoveColumns. But, regardless, you need to remove any explicit reference to that column in the code. Otherwise, on files that do not have that column you will receive the error you are getting.
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.
