What is the proper syntax for the CSV Reader module, column type?
What is the proper syntax for the CSV Reader module, column type? All columns are being read in as strings, but I want col6 to import as a Date. I assume I am placing it in the correct place? And can I just select this one column, or do I need to designate all column data types as well?
Comments
For the CSV Reader column types, you can use the Table Colum Type Input module to specify the types for one or more columns. (You can find this Module in the Module Library, or simply right click on the green input parameter, and this module should pop up as a suggestion.).
As an example, in the image below, a CSV file is read in, and Col6 is specifiedas a DateTime type.
So does Composable treat all fields as text on import and you need to use the Table Column Type Module if you want it to import as another data type?
Also, if I have multiple fields that are Date format can I put multiple columns in one Table Column Module, ie. col1, col6, col10, etc? And if I have other formats I need multiple Table Column Type Modules for each one?
For the CSV Reader (e.g., handles txt files), Composable treat all fields as text on import and you need to use the Table Column Type Module if you want it to import as another data type. For xlsx files (XLSX Reader), Composable provides more options (e.g., data type, calculate formulas, etc.).
You will need to have a separate Table Column Type Module for each field, regardless if it is the same type or not. So you can pipe in several of these modules into the same input on the CSV Reader module.