Alteryx workflow throwing error - Double fields can only be joined to other double fields.

[umashankar_cns]

Hi Experts,

My alteryx workflow throws this error - "Join (3) Double fields can only be joined to other double fields."

But in the join condition, none of the fields have the data type defined as 'Double'

Not sure why the error is traced otherwise

Can you please advise 

Thanks,

Umashankar

[Kottapally_Ramesh]

Hi Umashankar,

Please check Right & Left join fields should have same data type. In the attached screenshot first 3 fields has same, but check for the remaining fields.

Share the workflow to investigate further. 

[apathetichell]

sometimes changing field types in the join field does not prevent these kinds of messages - your right join fields in yellow had their type changed in the join tool - and these were probably double previously in the workflow. throw a select tool on the datastream prior to the join tool and change them to a fixed decimal there.

[dhrathod]

Use a select tool before right and left anchor of join tool, ensure the fields which are used in join tool have same data type. To elaborate further,  ensure data type is double in both select tool.

[apathetichell]

@dhrathod- doubles aren't ideal for joins - i'd use your strategy and use fixed decimals instead (19.6)...

[caltang]

You're not going to fix it by changing the data types within the Join tool, it has to be done before the Join tool. As what @apathetichell said, better to standardize both sides to one data type... and doubles aren't the best. If you can, you can try with FD as suggested, or make a new field and ToString() the keys you have in mind, use that to Join. Then within the Join, get rid of them. That should solve your problem.

[New_learner2025]

I ma getting the error too, I dont understand why

[New_learner2025]

please refer to the data sets mentioned in the screenshots and advise how to move  forward

[apathetichell]

your join tool says id is a byte not a double. byte is an ultra low memory field type. Both fields should be integers.

[dhrathod]

Rule : while using join or find replace tools, always ensure that the base fields are converted to string to avoid such errors.

you can use select tool before join tools to ensure quick fixes.

mark it as solution, if it works for you