<< Click to Display Table of Contents >> Navigation:  Sources > CSV

CSV files are referenced by name without extension when using FromFolder or by "data" when using FromFile method.

Supported field dividers are: comma, semicolon and tab.

Column naming convention is the same as for Excel files - A, B, C, etc. To get row number use _row field.

If first row is header row, columns can be referenced by its names from first row and firs row is skipped. To use this mode pass true as first parameter, f.e.

 

select * from sample(true) where City='Barcelona'