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

Custom append mapping unavailable in output tool

Alteryx Partner

Hello community,

 

I am fairly new to Alteryx and I was looking for resource to understand why the output tool wouldn't let me choose the custom Append Mapping when writing in an PostgreSQL through ODBC.

 

Any help is appreciated here as I struggle to figure it out!
Thank you!

 

output-custom_append.png

 

 

 

 

Alteryx Partner

Hi @jdemeaux,

 

The solution to your problem is fairly simple.

 

Before appending the data to an existing table, you 've to specify the schema name with the table name in the correct syntax with the correct spelling (area marked by the red rectangle).


Image.png

 

Also, the table you're appending to must contain the same column names with that of the data you're pushing through Alteryx. Only then the manual mapping option will become available to you.

 

Thanks.

Alteryx Partner

Hi @grazitti_sapna
Thanks for your help.

 

The table name was correct, I just hid it in my screenshot.

 

The columns names are not the same on both side of the output tool, so I understand this is the cause of the issue.
It somehow doesn't make sense because I'd use the manual mapping option specifically when the name are different (if they are identical the 'Map by name' option is sufficient). Or am I missing the point?

Thanks again!

Custom manual mapping with the select tool is a good workaround indeed.

But the question remains.

Maybe an issue with ODBC and/or PostgreSQL ?

Alteryx Partner

Hi @jdemeaux,

 

I tried pushing data into an empty table in Vertica DB and saw that the custom mapping function is available irrespective of the destination field names.

 

Image.JPG

 

I would suggest you try installing the ODBC driver again or try pushing the data into another table. This error can also occur due to an older version of Alteryx. You can also try installing the newer version.

 

thanks.

 

Labels