Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Field type is always changed lead to some execution error for the workflow

187
8 - Asteroid

Hi Alteryx Engineer,

 

My scenario is  I place an empty excel file and I used a dynamic input tool to use it as a template , but seems it is empty all values are read as Double type, so I can't force change it to String type.  then I used one of the field inJoin tool, so if there is data flushed into this excel file , there is no error for execution, but if there is not , then I get "String fields can only be joined to other string fields" error. Any advice for avoid of this error?

 

1 REPLY 1
binuacs
21 - Polaris

@187 Is there any reason why you are using the blank excel file as a template in the dynamic input tool? I think by default the blank column will be converted as double in Alteryx.

Labels
Top Solution Authors