Data can take on many forms, shapes, and structures. Sometimes, you may be set to jump right into analysis, but usually this is in a data competition. In the real world, data is messy and a data professional's job is to organize data in a way that can be queried to provide valuable meaning. Common data transforms include:
Pivoting, Setting data types, Aggregations. The transformation we will conduct, is converting the DOB of users into their real age. To do this in Alteryx, simply drag the "Formula" tool from the tool palette and connect it to the output anchor of the "Data Cleansing" tool. In the configuration panel, you will be prompted to "Select a column." Select "Add a column" from the drop-down and name it "Age." To calculate a person's age, we need to subtract the current date from the date of birth. For that, enter "DateTimeDiff" where it says, "Enter Expression here." Replace "dt1" with "DateTimeToday()" and "dt2" with "[Birth Date]." The "u" in the expression is the "units." Hence, in this case were working with years, so replace the "u" with "Years." Now in the end we just need to change the Data type to "Int16."
Awesome - now you know how to structure a basic workflow in Alteryx.
Pivoting, Setting data types, Aggregations. The transformation we will conduct, is converting the DOB of users into their real age. To do this in Alteryx, simply drag the "Formula" tool from the tool palette and connect it to the output anchor of the "Data Cleansing" tool. In the configuration panel, you will be prompted to "Select a column." Select "Add a column" from the drop-down and name it "Age." To calculate a person's age, we need to subtract the current date from the date of birth. For that, enter "DateTimeDiff" where it says, "Enter Expression here." Replace "dt1" with "DateTimeToday()" and "dt2" with "[Birth Date]." The "u" in the expression is the "units." Hence, in this case were working with years, so replace the "u" with "Years." Now in the end we just need to change the Data type to "Int16."
Awesome - now you know how to structure a basic workflow in Alteryx.