During our last training sessions, we received feedback that having a cheat sheet would help the trainees immensely. In view of the “Open Book” concept of the exams, we thought it would be a good idea to share them with everyone (and use them DURING the Alteryx Core exam)!
Input / Output
|Check the data at any point in the workflow. Get information such as min/max values , averages, and distributions.|
|Bring data into the workflow. To do this, use the Input Data tool itself or drag and drop the files directly onto the Canvas.|
|Bring data out of your workflow. Select your desired file type and location (don’t forget to check the overwrite setting.|
|Quickly create a table for text input that can be used in the flow.|
|Paste a column with specific values to your rows. If you use multiple rows for this, the dataset is increased for the number of rows.|
|Find a piece of text in the F-input and the R-input indicates which piece of text to replace it with.|
|Connect 2 data sources based on a column that matches. Matching data is put on 1 line.|
|Paste 2 or more data sources on top of each other. By default, the columns with the same names are used for this. You CAN manually set this however|
|Use this tool to :|
– replace all NULL values in 1 or more columns with an empty string or 0
– replace all capitals with small letters of vice-versa
– remove all numbers from cells
– remove all letters from cells
– remove tracing or leading spaces
– remove nullrows
– remove null columns
|Split data by attribute (T for True , F for False)|
|This tool gives you the opportunity to make your own calculations. Specify in which existing or new column the tool can store its data and do not forget to set the data type correctly.|
|Allows you to select a portion of the results (first N , last N etc.)|
|Use this tool to leave columns, change names or change the data type.|
|Allows you to select a portion of the results (50-100 for lines 50 to 100 etc.)|
|Sort the lines in your data.|
|Return every first line with a unique value in a specific column. The rest of the lines are returned through the D-output|
|gives you the option to group data, add up, average or count how often the same value occurs|
|Move column names to the rows. In the settings under “Key Columns”, indicate which columns should remain as they are.|
|Turn rows into columns and group the data.|
|Convert String data to Date , Time or DateTime or vice versa. |
Specify at Date -> String in which format you want to see the String data.
Indicate at String -> Date in which format you supply the String data.
Text To Column
|Seperate text into new columns. Specify at Delimiter which character should be sliced/seperated.|
Don’t forget that in addition to this cheat sheet there are a number of help options:
- Right click on the tool in the Toolbar and choose Example to see an example of the tool, here you can see how the tool is used and set up.
- Right click on the tool in the Toolbar and choose Help to go to the Alteryx help page for this tool. Here is explained in reasonable detail what all options of the tool do.