Export Table Data From Database into Multiple Excel Files Using Alteryx

For this exercise  you need Oracle or any other database and Alteryx tool.

Get Alteryx from here -> http://www.alteryx.com/

Design the workflow as follows

In the 1st step, we are going to use "Input Data" tool to connect to Database and to read the data from table.

Create sample employee table using following sql

create table employees as 
    select level empno,
           'name' || level ename,
           case
              when level <= 10 then 10
              when level between 11 and 20 then 20
              when level between 21 and 30 then 30
              when level between 31 and 40 then 40
              when level between 41 and 50 then 50
           end
              deprt_id
      from dual
connect by level <= 50



In Step-2, use Alteryx "Formula" tool to name the files dynamically

In Step-3, use "Output Data" to write the files.