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:
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
Great thanks @danilang!
Re-formatting solved the issue, maybe I should use csv to avoid such issue..
