Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Saving to db created additional columns in the table

mszpot89
9 - Comet

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

3 REPLIES 3
danilang
19 - Altair
19 - Altair

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

mszpot89
9 - Comet

Great thanks @danilang!

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

danilang
19 - Altair
19 - Altair

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