asked on October 24, 2019
In a sheet where the first few rows might be blank or filled with comments related to the sheet, is it possible to apply filters only beneath a certain "Header" Row?
An real life example attached
Here is another example. What we’re seeing is that the Data structure has a list of object with each object representing a row. This “Row Object” has each key as the header… but it looks like when we throw the CSV attached it reads the header from the first Row and reads from there. Is there a less assumptive way to render the data so that it’s represented correctly?
⋅ October 25, 2019
Hello, Camille,
Thank you for writing to us.
Could you please reattach the real-life example?
Also, it seems we don't have access to view the shared example.
Could you please provide us with access?
If we understand your case correctly, it seems as though your CSV data may contain rows with custom data (for example, some comments) before the actual CSV data begins.
In such a case, we kindly suggest preparing the data on the server-side (removing non-CSV rows) before passing it to Flexmonster.
Waiting for your response.
Best Regards,
Vera
⋅ October 28, 2019
Yes, Here would be a quick screenshot as an example.
⋅ October 29, 2019
Hello, Camille,
Thank you for providing the screenshot for illustration.
We would like to confirm that for such cases the recommended approach is to pre-process the data as suggested in the previous answer.
Please contact us in case of questions.
Best Regards,
Vera
