q
List of commands for q:
-
q:tldr:16f87 q: Read data from `stdin`; '-' in the query represents the data from `stdin`.$ ${output} | q "select * from -"try on your machineexplain this command
-
q:tldr:3fbc3 q: Query file with header row.$ q -d${delimiter} -H "SELECT * from ${filename}"try on your machineexplain this command
-
q:tldr:6ea84 q: Join two files (aliased as `f1` and `f2` in the example) on column `c1`, a common column.$ q "SELECT * FROM ${filename} f1 JOIN ${path-to-other_file} f2 ON (f1.c1 = f2.c1)"try on your machineexplain this command
-
q:tldr:79dc7 q: Format output using an output delimiter with an output header line (note: command will output column names based on the input file header or the column aliases overridden in the query).$ q -D${delimiter} -O "SELECT ${column} as ${alias} from ${filename}"try on your machineexplain this command
-
q:tldr:a4b7c q: Query `.tsv` file.$ q -t "SELECT * from ${filename}"try on your machineexplain this command
-
q:tldr:c73f0 q: Query `.csv` file by specifying the delimiter as ','.$ q -d',' "SELECT * from ${filename}"try on your machineexplain this command