Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Read CSV File in Alteryx

This section explains how to load or read data from CSV files into the Alteryx designer with an example. First, we created a new workflow and drag and dropped the Input Data Tool into the Alteryx Designer window. 

Read CSV File in Alteryx 1

Within the Configuration tab, click on the down arrow button to connect to a File or Database.

load CSV Files in Alteryx 2

It opens the following Data Connections window. Please select the Files tab to see the list of supported file types by the Alteryx. In this Alteryx example, we want to read CSV file data. So, please click on the Select File button

load CSV File in Alteryx 3

Let me choose the Customers CSV file from the Alteryx Sample data folder.

Read CSV File in Alteryx 4

You can see the CSV file information and the preview of the first 100 records on the Alteryx left side configuration pane.

Read CSV File in Alteryx 5

Please use the Browse tool to see the data inside that CSV file. So, drag and drop the Browse tool to the designer and connect the CSV Input Data tool to Browse and click the Run button.

Read CSV File in Alteryx 6

From the below Alteryx read CSV file workflow image, you can see all the CSV files’ records.

Read CSV File in Alteryx 7

If you click on the Metadata tab, you can see the CSV file column information such as Name, type, size, and source name.

Read CSV File in Alteryx 8

Filed Under: Alteryx

  • SQL DML, DDL, DCL & TCL Cmds
  • SQL NOT EXISTS Operator
  • SQL UPDATE from SELECT
  • SQL AFTER UPDATE Triggers
  • SQL Get Column Names in Table
  • SQL IF ELSE
  • SQL ACID Properties
  • SQL FOR XML PATH
  • Java Two Dimensional Array
  • Java Perfect Number Program
  • Java Count Digits in a Number
  • C Compare Two Strings Program
  • C Print Prime Numbers 1 to 100
  • C program to Reverse a String
  • C Palindrome Number Program
  • C Program for Palindrome String
  • C Remove Duplicate String Chars
  • C Square of a Number Program
  • C Sum and Average of N Number
  • Python Fibonacci Series program
  • Python Area Of Circle Program
  • Python Prime Numbers 1 to 100
  • Python Program for Leap Year
  • Tableau Rank Calculation
  • Tableau Google Maps usage
  • Power BI Format Dates
  • Power BI Top 10 Filters
  • Power BI – Create Hierarchy
  • Power BI DAX Math Functions
  • SSIS Transformations
  • SSIS Incremental Load
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • R Programming Tutorial

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy