Change the data type and system not "Run"

[Jeffrey_lau]

Hello, Alteryx community!

I am very enjoying learning about Alteryx when watching the Interactive Lesson videos.

There is a homework that I have done is to make an unclean excel [avocado-not clean.csv] into a clean one (need to be same)  [avocado.csv].

by far the data amount, date, number all the same, but the format is a little wrong [Avocado clean final]

The question I want to ask mainly is about when I change the data type in to "Date" and "Double" , it won't let me run the system

[fmvizcaino]

Hi @Jeffrey_lau ,

To use a join or a multiple join tool, the key fields must have the same exactly format, so it won't be possible for you to join two columns where the first one is a text and the second one is a number, for example.

Best,

Fernando V.

[Jeffrey_lau]

I have fix the format and can put the "double" type, but the only thing I don't know is the "Date" one

[Jeffrey_lau]

the multiple join tool is just for checking the differences

[fmvizcaino · Accepted solution]

Hi @Jeffrey_lau ,

Attached is an example showing another way of doing some of the steps, but also a way of changing the format to date.

Best,

Fernando Vizcaino