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?
Discussions about CSEntry
1 post • Page 1 of 1