Designer sets the number of fields and the file types based on the 1st file read. Multiple files are read using the wildcard format, like *.csv or 2019*.csv in a single Input Data tool, as long as the files all contain the same number of fields, where the data types for each field are the same. All other Quick connections use another tool.Quick connect: For SQL or Oracle Quick connect, you can either use a pre-existing saved connection or create a new saved connection.Bulk opens a special dialog allowing you set up a bulk connection for the selected connection type.From here, select the Net Service Name as defined in your tnsnames.ora file that you want to use for this connection as well as the username and password credentials. OCI launches the Native Oracle OCI connection manager.OleDB launches the native Windows OleDB manager. ![]() ODBC launches the ODBC connection window that displays a filtered list of DSNs on the system that use that particular driver.Once the tool is installed, the Input Data tool changes on the canvas to the tool you selected from the Data sources tab. Read the instructions on the page carefully. Tools: If you select Quick connect for a tool you have not installed, a browser opens to the Alteryx Community for you to download and install that tool.Data sources displays supported and frequently used data sources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |