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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Remove the Suffix from my ODBC Database Output file

Meteor

Hello,

 

my output is a MS SQL database table, but every time i run it, it adds my username as a suffix to the table name, is there away that i can remove this, that it only shows like dbo.table name? 

 

this is how the output tool configuration looks like now:

 

Alteryx Designer x64 - New Workflow3__2018-09-21_10-54-17.png

 

I really appreciate your help

Rawan

Community Operations Manager
Community Operations Manager

@Rawan,

 

You may want to check your driver settings or the database. Alteryx will not add anything to your data or table names unless you specify to do so at the bottom of the Output tool. In your Output tool you are not specifying to add anything to the table name, so this more than likely is a driver or database setting.

 

DanM

Highlighted
Meteor

Thanks so much for responding @DanM. I ended up solving the problem by editing the Output File name and add "[dbo].". now i have it the way i wanted it.

 

Thanks again

Rawan

Labels