Having an umatch String issue

[Jenner09]

Hi,

I am new with Alteryx and trying to design my first Workflow. So far all is good except when i try to join both data set i keep having an unmatch "v-string" issue. All the fields are v-string but it still not working for me. Any pointers will be great to have.

thank  you

[Qiu · Accepted solution]

@Jenner09 
Changing the data type in the Joint Tool only affects the output, not the input.

So you need to put a Select Tool before Join Tool to change the data type.

[BretCarr · Accepted solution]

In other words, you need to change the values to strings in the select tool before the join. If you need the data to run through the cleanse tool before you change the values to strings, you’ll need another Select tool before the Join tool attempts to Join.

[Jenner09]

thanks Qiu, it worked!!!

[Jenner09]

Brett- that approach did work for me. Thank you for the help!

[BretCarr]

Happy to help! I was there once, too. 😀