Hi, I have a simple script to find and export records from two tables.
Table 1, "SOWs": NameOfSOW, SOW_ID, VendorName, QuotedPrice, DateStarted, EndDate, Status
Table 2, "POs": SOW_ID_po, POvalue, POnumber, StartingValue
The relationship is keyed on SOW_ID, I'm sure you guessed. My script finds all active SOWs and exports them and their related POs (not all SOWs have more than one PO) to an xlsx. The problem is that the spreadsheet exports all of the fields from "SOWs" only once, even if there are multiple POs, so it looks like the attached. You can see - Project2 has three POs but the SOW fields only got exported in the first row. How do I get the export to include all of the related fields in each row?
Thanks for the help!