Saving to db created additional columns in the table

[marcin2x4]

My workflow (OLE db connection) fails to save data to the table as Alteryx sees additional blank columns.

Is it something on server side or alteryx?

This is how MS SQL studio shows the data:

[danilang · Accepted solution]

hi @marcin2x4

This is actually on the Excel side.  Your worksheet is reporting that the extra columns are part of the active area of the sheet and Alteryx is importing them.  You can try removing them from the sheet or use a Select tool in the workflow to remove the extra ones before saving to the db

Dan

[marcin2x4]

Great thanks @danilang!

Re-formatting solved the issue, maybe I should use csv to avoid such issue..

[danilang]

You'll find that excel will export the blank columns to the csv as well.   As long as excel thinks that they're active, it'll output them

Dan