Error using Join Multiple tools

Dear Community,

I would like to ask how can i solve the following issues as i have change the all the join field to the type : V_Wstring and Date accordingly but it still persist the following errors.

May i know normally what is the root cause of following errors?

Thank you.

Common Use Cases

Accepted answers

mceleavey

Hi @SH_94 ,

No problem. If all your dates are in that format I would still recommend using the date parse tool to convert to the Alteryx format and join on those converted fields. You can simply drop them afterwards, but it does ensure you are joining on a consistent data field.

shreyanshrathod

@SH_94 ,

CHanging field types in the JOIN MULTIPLE tool won't help. These changes do not occur prior to joining.

Thus, use a SELECT tool before you feed the data into JOIN MULTIPLE tool.

As @mceleavey mentioned, DATA TYPES should be same BEFORE they are fed into the JOIN MULTIPLE tool.

If your dates are in the ALteryx standard format 'yyyy-mm-dd' then you can convert it in a SELECT tool, else use a DATETIMEPARSE tool.

(******Check the metadata of the ingoing datasets before JOIN MULTIPLE tool******)

Regards,

Shreyansh Rathod

All comments

suby

Did you try running the flow again and see if that works and share the workflow with the data.

shreyanshrathod

@SH_94 ,

Changing the field types from the embedded Select window in JOIN MULTIPLE Tool won't help.

Change the data types in previously connected SELECT tools and you should be good to go.

Regards,

Shreyansh Rathod

SH_94

Hi @shreyanshrathod ,

I have checked and all the format are as per screenshot below but the issues still persist. May i know what it means for the following three cartesian joins mean?

Thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703