Apologies if this has been asked before but I couldn't find an answer to my problem.
I am importing a list of stock items from various suppliers using a CSV file provided by the supplier.
The CSV file contains various fields but my query relates to the 6 individual fields for image urls in the file: URL1, URL2, URL3, URL4, URL5 and URL6. As a key, I am using the field 'Handle'.
When I import the file into FM, everything works fine. My issue comes when I try to export the file to an Output CSV file which I will be importing into a web page.
I need to export records containing all the information in the record which is fine but I also need to have a separate row for each URL which appears in the record.
The Input CSV file looks something like this:
Handle, Description, Price, Quantity, URL1, URL2, URL3, URL4, URL5, URL6
I need my Output CSV file to resemble :
Row 1: Handle, Description, Price, Quantity, URL1
Row 2: Handle,URL2
Row 3: Handle, URL3
Row 4: Handle, URL4
Row 5: Handle, URL5
Row 6: Handle, URL6
Thanks in advance.