Different ways to Bring-In Data to Match your Style
We’ve seen our users bringing in their data using different techniques. Here are the ones we’ve seen the most that are the most fascinating. Try one of these or come up with one that matches your own style!
Standard Drag and Drop
This is the one you will see on Alteryx training videos. Find the tool you need on the tool palette, click on it to select and hold it, then drag and drop it into your canvas.
Insert tool in canvas
One of our Grand Prix winners used this one during competition and under lots of pressure!! Right-click on the desired place on the canvas then choose Insert. This will present you with all the tool categories - navigate to your tool from there.
This handy dandy tool allows you to point to a directory to show all the files contained. From there (as explained above), drag one or more files from the list and drop them to the canvas.
Set New Record Limits
The Record Limit setting in the Input Data Tool can be very helpful at workflow design time. Limiting the number of records coming in while building your workflow will speed up testing. This will return the top records.
When in need of just the metadata, Record Limit to -1.
Record Limit set to 0 returns the maximum size of an Int64.
No Data File type… No Problem!
Want to open a non-data file type? Bring it on!
One common use case is an Alteryx workflow (.yxmd). In the Open a Data File dialog box, make sure to select All Files (* *) forFiles of type.
For the Resolve File Type dialog box, use \0 as the delimiter and uncheck the First Row Contains Field Names box.
All your data will be placed in one field, therefore, make sure to set the Field Length (in the Input Data Configuration) to a much bigger size to accommodate all the data.