Export - Single Record has multiple fields
Posted: November 19th, 2015, 6:36 pm
Hello,
I am exporting my data to Csv format, and my application contains a roster.
If I select Number of Files Created: One File and Output of Multiple Record Occurrences: All in One Record (see attached Export1) a single Csv file is created, but for each field it repeats twenty times- A1_01, A1_02, A1_03......................A1_20.
The first field contains the value captured, the others are blank.
If I select Number of Files Created: Multiple Files and Output of Multiple Record Occurrences: As Separate Records (see attached Export2) then the fields aren't repeated, but I now have three separate records, which I then have to join manually.
Any idea how to generate a single file without repeating fields?
I am exporting my data to Csv format, and my application contains a roster.
If I select Number of Files Created: One File and Output of Multiple Record Occurrences: All in One Record (see attached Export1) a single Csv file is created, but for each field it repeats twenty times- A1_01, A1_02, A1_03......................A1_20.
The first field contains the value captured, the others are blank.
If I select Number of Files Created: Multiple Files and Output of Multiple Record Occurrences: As Separate Records (see attached Export2) then the fields aren't repeated, but I now have three separate records, which I then have to join manually.
Any idea how to generate a single file without repeating fields?
- Export1.png (18.06 KiB) Viewed 34005 times
- Export2.png (21 KiB) Viewed 34005 times