1 Reply Latest reply on Jun 23, 2011 10:01 AM by aammondd

    Adding 2 rows of header data to a CSV export

    NicoleHartman1367

      Title

      Adding 2 rows of header data to a CSV export

      Post

      Hi,

      I am trying to create a CSV export that includes two rows of headed data which is required by our SAP workbench where the data is being imported. 

      I notice the merge data export format, but I am not sure how I can use this to export two data files (my header file and my data file) and then merge them into one file. 

      Does anyone know how to do this or have a better suggestion on how to achieve my desired results?

      Thanks!

      Nicole

        • 1. Re: Adding 2 rows of header data to a CSV export
          aammondd

          You could merge a single header data row with your data into a merged export table. That way you could keep  the 2nd header row in a temporary table.

          Import that row and your data into an export table then export them all. you could add a sort order field to your export table and make sure your header row is sorted to the top then export it in the sorted order.

          I dont have anything handy at the moment to mock up such an idea.