Custom append mapping unavailable in output tool

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

Accepted answers

grazitti_sapna

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).

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.

All comments

grazitti_sapna

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).

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.

jdemeaux

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!

sultania_p

In order to do the custom mapping enabled, please make sure the table you want to map with (I mean output table) should be created in the database first and once done then you will be able to see the table structure to map it manually! Hope it helps.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335