🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Does Flexmonster support setting a header and filtering on a row other than row 1?

Camille Morell 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?

3 answers

Vera Didenko Vera Didenko Flexmonster 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,

Camille Morell October 28, 2019

Yes, Here would be a quick screenshot as an example.

Vera Didenko Vera Didenko Flexmonster 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,

Please login or Register to Submit Answer