Hi,
I have huge csv files from which only certain amount of rows are useful for me. Is it possible to import only some rows according to a predefined criteria? the criteria would be the value of a/some column/s on each row.
for example: only load the rows where the value of the column3 <> 0.
The import menu doesn't offer such an option and I've tried the IGNORE command inside the LOAD but I don't really know how to use it
Thanks in advance