Connecting to data
The first step to bring data into Alteryx is connecting to it. There are four connection options we will review that will prepare you to connect to a variety of files and databases. These include the following tools, Input Data
, Text Input
, Map Input
, and Connect In-DB
as shown in the following image:
Input Data
The Input Data
tool can be found under the In/Out tool palette. Connect to a file or database to bring data into your workflow. Let's look at how we can connect to a file by configuring the tool:
- Open Alteryx. You should see a blank canvas with the tool palettes at the top and the workflow configuration on the left.
- Drag the
Input Data
tool from the In/Out tool palette onto the canvas. - In the Configuration window, select a file.
- In the
Open
dialogue box, navigate to the\Learn Alteryx\Chapter 02\
directory and select theFlorida Local Data for Better Health.csv
file. - You will now see that you are connected to the file, with the Options and Preview sections populated as...