Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

change data type

haoyu1227
6 - Meteoroid

When i run the workflow in my local computer, it is suceefully with no bug. But when i use same XML file as input and run same workflow in the server, it has bug and because one of column of output change type to string automatually. So when the output connect to database, it appears bug. Could someone explain to me or face same problem before?

 

Thank you for your reading.

2 REPLIES 2
ArtApa
Alteryx
Alteryx

Hi @haoyu1227 - It's difficult to troubleshoot without your data and workflow. However, please try adding a Select tool with the following setting:

ArtApa_0-1655352552983.png

 

It will make sure that your output field is in the right format.

digitalmemo
8 - Asteroid

In addition to @ArtApa try using Auto Field tool as well.

digitalmemo_0-1656175808698.png

Labels