Hello I am very new to Planet Press Connect.
I have one text file with multiple purchase orders. Each purchase order has item detail.
I have created a data model with 2 extraction steps (and a repeat step) that will separate the text file by purchase order and item detail.
I need to export the text file to separate CSV files. So if there are 3 purchase orders within the text file, I need 3 separate CSV files.
The 2 extraction steps have created 2 data tables named “record” and “record.itemdetail”.
What I don’t know is how to combine the data table “record” and the data table “record.itemdetail” as one record line within the CSV file.
Import - TEXT FILE
Address: 123 Twig St
Description: Box of Cereal
Export - CSV FILE (What I would like the output to look like below)
PO#, Ven#, Address, Item#, Description, Qty
12345, A9999, 123 Twig St, 77777, Box of Cereal, 5