community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Saving to db created additional columns in the table

Asteroid

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?

 

image.png

 

This is how MS SQL studio shows the data:

image.png

Aurora

hi @mszpot89

 

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

Asteroid

Great thanks @danilang!

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

Aurora

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