Forum Discussion
Solved
Can removal of certain rows be automated?
Hi, I will be getting an Excel file with some 1000 rows and 10 columns. The rows that have a value of N1 in column F and a value of N2 or N3 in column H should be removed (predicted outcome: abo...
- Yes.
You can load with any sql client.
i.g.
https://support.microsoft.com/en-us/office/use-microsoft-query-to-retrieve-external-data-42a2ea18-44d9-40b3-9c38-4c62f252da2e
ms query
or
https://e.anyoupin.cn/EData/?
online sql
sql,
Select * from sheet1 where not (f6 like 'N1' or f8 like 'N2' OR f8 like 'N3')
Select * from sheet1 where not (f6 like 'N1' or f8 like 'N2' OR f8 like 'N3')
Do you mean that I first have to load the Excel file into an SQL data table and then with a query get the records that match the inclusion criteria?
- Yes.
You can load with any sql client.
i.g.
https://support.microsoft.com/en-us/office/use-microsoft-query-to-retrieve-external-data-42a2ea18-44d9-40b3-9c38-4c62f252da2e
ms query
or
https://e.anyoupin.cn/EData/?
online sqlThanks much, even though I prefer the SQL Online service from https://sqliteonline.com/ over one that runs on a Chinese server. If one clicks Import, .csv files are also accepted. Doesn't get easier than that. 🙂
Thanks for your feedback.
Yes,Online service from https://sqliteonline.com/ looks like easier.