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

Alteryx designer Discussions

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

Write Data returns "No Columns Returned"

Asteroid

I made a ODBC connection and wanted to add excel data to the MS SQL Server data.

On Write-in DB step I get the Columns error. Is there a specific format of table name that has to be applied in Table name field?

 

The table is part of a schema but "schema_name.table" doesn't help.

image.png

 

 

Highlighted
Asteroid

Ok - I found it :)

Table name in Write in-db should go like this: Database_name.schema.table

Labels