[COMPASS-7099] The export array of objects after aggregation to CSV is separate each field of the object Created: 09/Aug/23  Updated: 01/Nov/23  Resolved: 01/Nov/23

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: 1.37.0, 1.38.0, 1.38.1, 1.38.2, 1.39.0, 1.39.1
Fix Version/s: No version

Type: Task Priority: Major - P3
Reporter: Yevhen Novytskyi Assignee: Julia Oppenheim
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

OS: ubuntu 22.04
node.js / npm versions: v14.17.1 / 6.14.13
Additional info:


Attachments: PNG File image-2023-08-09-15-57-49-487.png     PNG File screenshot-1.png     PNG File screenshot-3.png    
Documentation Changes: Not Needed
Sprint: Up for triaging

 Description   

Problem Statement/Rationale

When exporting data to CSV format in version 1.36.4, where an array of objects is involved, the array is recorded as a single cell with a string value. However, in subsequent versions, the array is split into individual fields for each object, occupying multiple cells in the document. This new behavior significantly reduces data readability compared to the previous version.

Steps to Reproduce

To replicate the issue, follow these steps:

  1. Open version 1.36.4 and 1.37.0 or the latest of the application.
  2. Export data containing an array of objects to CSV.
  3. Observe the formatting of the exported CSV file.

Expected Results

We expect the exported CSV file to maintain consistent formatting across versions, ensuring that arrays of objects are presented in a readable manner.

Actual Results

In version 1.36.4, the exported CSV file contains arrays of objects within a single cell as a string value. In later versions, the array is split into multiple cells, corresponding to the fields within each object, leading to reduced readability.

Action Requested:

We kindly request the Engineering team to address this issue in one of the following ways:

  1. Option to Choose Array Export: Introduce a feature that allows users to choose how arrays are exported in CSV, either as single cells or split into individual fields.
  1. Revert to Previous Behavior: Alternatively, consider reverting to the previous behavior where arrays were exported as single cells, as it provided better readability.

Additional Notes

Sample data for reproduce - {events: [

{symbol: 'A', symbol: 'B'}

]}.

This issue significantly impacts the usability of exported data and hampers the analysis process. We appreciate your prompt attention to this matter and any potential solutions to improve the exporting functionality while maintaining data readability.



 Comments   
Comment by PM Bot [ 09/Aug/23 ]

Hello z.novytskyi@gmail.com, thank you for reaching out to us! The team will review your issue and get back to you soon as soon as possible.

Please review your issue to ensure you've included your environment details and have attached relevant logs (with any sensitive data redacted), so that we're best able to provide you a timely and thorough response. Thanks again!

Generated at Wed Feb 07 22:45:22 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.