Multi-file support

[robot-accomplice]

Have you considered implementing multi-file support? I have a use case that would benefit from the ability to create a result set that is the product of "joining" two or more CSVs.

[kpym]

You can do this already (using join). Considère two files:

• test1.csv:

  id,first_name,last_name,email
  1,Louis,Washington,
  2,Sean,Burton,sean@example.com
  3,Peter,Smith,peter@example.com

• test2.csv:

  id,phone
  1,1234567890
  1,2345678901
  2,3456789012
  4,4567890123

Then you can use join like this

> csvq -f csv 'select t1.*,t2.phone from `test1.csv` t1 join `test2.csv` t2 on t1.id=t2.id'
id,first_name,last_name,email,phone
1,Louis,Washington,,1234567890
1,Louis,Washington,,2345678901
2,Sean,Burton,sean@example.com,3456789012

or with left join:

> csvq -f csv 'select t1.*,t2.phone from `test1.csv` t1 left join `test2.csv` t2 on t1.id=t2.id'
id,first_name,last_name,email,phone
1,Louis,Washington,,1234567890
1,Louis,Washington,,2345678901
2,Sean,Burton,sean@example.com,3456789012
3,Peter,Smith,peter@example.com,