Q eye - delete many rows in ONE click, and not possible to open .QVD with 23 GB

More
3 years 7 months ago #22137 by Henrik
I have downloaded your app for editing .QVD files. Version 6.5.0.9 (latest??)

I have two problems:

I do not understand how to delete all rows with a certain value in a column with ONE click, I do not want to delete one row each time. I can send a screenshot to show what I mean. I need to delete 5.000.000 rows...

Next problem.

I have a VERY large .QVD file. 23 GB. 150 columns and probably 15.000.000 rows.

I can not open the file (even with your latest version that should be able to open very large files).

I get this message:

"Access violiation at address ................ in module Qeye.exe Read of address............"

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22138 by Peter.Jonson
Thank you for using the support forum

I do not understand how to delete all rows with a specific value in a column with ONE click, I do not want to delete one row each time. I can send a screenshot to show what I mean. I need to delete 5.000.000 rows...


This option is currently not supported but we can add it for you
I assume that you want to delete 'Marked Values'

Regarding the AV:

Have you got a smaller file which is failing as well?
If so can you provide it to us, so we can download it and test

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22139 by Peter.Jonson
Also to open 23 gig file you would need a lot of memory.

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22140 by Henrik
Yes Peter

I want to delete all rows that are "marked"

(I search for a certain value in a certain column - and all "hits" should be "marked" - and all should be possible to be deleted in one go).

Am I really the first user who want this option? That is what most people do "all the time" in Excel...

Right now I am not able to send you my file since the data is confidential. I do this at my work at a large company.

I also guess the file is too big for my amount of memory...

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22141 by admin

Right now I am not able to send you my file since the data is confidential. I do this at my work at a large company.


We do not need any secret data file we just need an example file which is failing.

A number of people complained about AVs. No one provided an example.

It is very hard to fix bugs by guessing.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22142 by Henrik
Thank you Mike!

Fully understand!

I will try my best.

Will get back ASAP.

Henrik

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save