I'm trying to read a csv file that does not have a Header Row? What can I do about it?
Modify the CSV reader module to start at Row 0, and also to set the column row as -1
Composable will then assign the column names as: col0, col1, col2, …
You can follow this with a Table Query module to select and name the required columns, as in:
SELECT
[col0] as Rec_ID,
[col2] as TYPE,
....
FROM [t0]
Comments
Modify the CSV reader module to start at Row 0, and also to set the column row as -1
Composable will then assign the column names as: col0, col1, col2, …
You can follow this with a Table Query module to select and name the required columns, as in:
SELECT
[col0] as Rec_ID,
[col2] as TYPE,
....
FROM [t0]