antonycourtney / tad

A desktop application for viewing and analyzing tabular data
http://tadviewer.com
MIT License
3.19k stars 119 forks source link

Support "SKIP" parameter when reading file #201

Open yooakim opened 1 year ago

yooakim commented 1 year ago

We frequently import files that contains a header section (normally two rows). When we read this file using DuckDb the query looks as follows:

CREATE TABLE Spotify AS SELECT * FROM read_csv_auto('track-for-*.txt', AUTO_DETECT=TRUE,DELIM='\t',QUOTE='',HEADER=true,SKIP=2);

To open the same file with Tad we need to remove the two first lines. It would be very nice if Tad could support the SKIP parameter when opening a file.