Forum Discussion

WillRanzani's avatar
WillRanzani
New Member
4 years ago
Solved

Divergence with data extraction function in visual with downloaded XLS file

I have a table with 73.565 lines   When i use the Export Data button and generate the XLSX file (with 150k lines limit), the file "swallows" some lines of the table, bringging 73.556 lines (9 lines...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi WillRanzani ,

     

    You have to consider that

     

    1. the table may automatically aggregates some data.

    2. did not show rows that have no data.

    3. exist exactly the same rows.

     

    For this reason you may have to tweak your table visualization a little

    • Don't summarize 
    • Show items with no data

    • Add a Index column

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi WillRanzani ,

 

You have to consider that

 

1. the table may automatically aggregates some data.

2. did not show rows that have no data.

3. exist exactly the same rows.

 

For this reason you may have to tweak your table visualization a little

  • Don't summarize 
  • Show items with no data

  • Add a Index column

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.