Start Free Trial

Alteryx Designer Desktop Discussions

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

New user - Can these errors be fixed easily/quickly?

OILINCHEUNG
5 - Atom

Hi,

 

I'm a completely new user with no knowledge of Alteryx, new to the job! I've run a workflow for the first time and encountered errors. I'd be very grateful if someone could advise if these errors can be fixed easily/quickly by a new user and provide general advice? Unfortunately I'm pressed for time and need to determine if I can somehow fix this today or abandon Alteryx for the time being.

 

OILINCHEUNG_0-1664195233825.png

 

Many thanks,

Oi Lin

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

@OILINCHEUNG the first error which stands out to me there is the join error "Double fields can only be joined to other Doubles":

IraWatt_0-1664195472246.png

To solve this check the join tool which has errored (example shown above) and see what fields your joining on. The key is to ensure both the left and right inputs to the join tool has the same data type. You can change their data types using a select tool before the join:

IraWatt_1-1664195576072.png

 

You can find some good quick videos on how data types work here on the community https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958 or just check the docs your feeling brave https://help.alteryx.com/20221/designer/data-types.

 

 

 

OILINCHEUNG
5 - Atom

Thanks, Ira. I appreciate the advice. Any advice on how to identify what 'output 6' might be on those errors about the output connection not being valid?

IraWatt
17 - Castor
17 - Castor

@OILINCHEUNG if you click on the link next to the error it should bring you to the tool which has the issue. This may give you an idea of the problem: 

IraWatt_0-1664197371063.png

I cant see the tool name but I think its a user made macro.

 

 

Labels
Top Solution Authors