Change the data type and system not "Run"

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

Avocado.yxmd

avocado.csv

avocado-not clean.csv

1.PNG

Avocado Clean Final.xlsx

Input

Accepted answers

fmvizcaino

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

Avocado (1).yxmd

All comments

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

Avocado.yxmd

Jeffrey_lau

the multiple join tool is just for checking the differences

fmvizcaino

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

Avocado (1).yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703