Forum Discussion
Removing any columns causes errors
Hi
My source data is from a google sheet. It has not changed in any way - I have been working on it for the last month.
However, suddenly I am getting errors.
Today I re-imported the source and noted that as soon as I remove columns I get the following error:
"The column of the table wasn't found"
It does not matter which column I remove. I will continue to get that error until I added all removed columns back.
Yes, I updated gateway. Yes, I checked the advanced editor. Yes, I checked the types. No, I did not add any customer columns. The ONLY thing causing this error is when I remove a column. I even made sure to make not changes except removing columns (Applied steps shows Source / Navigation / Removed Columns. Am I missing a hidden setting that I might have accidentally activated?
Johalien
I think I figured it out - might be related to the credentials to access the data source.
I cleared my cache - went to "data source settings" and cleared all permissions - then recaptured them.
I was able to load this source again and make all changes necessary.
Anonymous - thank you for your assistance :)
9 Replies
Sometimes when I use Excel file as a source, I would get additional null columns. To prevent this, you can use Remove Other Columns to keep the columns you want instead of removing the columns you dont need.
