ASI List Magic

List Magic allows for each row in a CSV file to be read using a specified delimiter, then output as individual jobs through an outbound connector.

Input - Delimited file (e.g. comma or tab delimited text file)

Output - One Switch Job per row of data (first row must be the header/key values)

Each Job has a dataset named "ListMagic" which contains the values of the row from the delimited file.
Each job also has private data for each key - value pair.

Additional Private Data on each new Job:
data_rows: the total number of rows in the CSV file
this_row_number: the row number from the original delimited file

Example:

orderDate,productID,productName,stock,press,customer,quantity
11/30/19,ABC123,Business Card,Biz Card Shell,DIGITAL,Z Corp,500

Key                               Value
orderDate                    11/30/19
productID                     ABC123
productName              Business Card
stock                            Biz Card Shell
press                            DIGITAL
customer                     Z Corp
quantity                     500