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
11/30/19,ABC123,Business Card,Biz Card Shell,DIGITAL,Z Corp,500
productName Business Card
stock Biz Card Shell
customer Z Corp