On Saturday August 31st 2024 from 7:30 CET until 7:45 CET our licensing will be briefly unavailable for maintenance. During this period, activation or deactivation licenses will not be possible. Using already active licenses is not affected.
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