community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More
SOLVED

Join Rental Amount String Error

Hi I am joining two files together. One is a csv file and the other is an xlsx file. I am joining by specific fields and they are serial number and rental amount., but when I try to run the workflow, I get an error saying the String fields can only be joined to other string fields so I changed data type for Asset Rental Amount to a string to match the left rental amount but I am still getting the error. Does anyone happen to know why.

 

Best,

Chirag Gandhi  

Alteryx Certified Partner

Hey @Chirag_Gandhi07

 

You need to change the data type before the join (using a select tool) the change you made in the join tool only affects the results

Pulsar

Unfortunately, you have to change the data types BEFORE the Join tool.  Add a Select tool just before your Join and change them there.  Changing the data type in the Join tool itself changes the data after the join happens, not before, so it's still attempting to join a string to a number.  Does that make sense?

Yeah that worked! Thank you guys for your help! I'm new to Alteryx

Labels