Question

Create schema for CSV file

  • 15 March 2019
  • 1 reply
  • 9 views

Badge +3

 

Hi,

 

I'm trying to read in a CSV file that has no header information. Additionally the data is spread around several columns rather than in a single line.

 

Looks like the first row is junk.

The second is the site name.

The third is the site number.

Fourth is pressure information

Fifth is the date and start time of the data

6 onwards is the data

How do I first create a schema that FME uses before it tries to open the file? I attach a file as an example.

Thank you.


1 reply

Userlevel 2
Badge +17

Not clear what you need to accomplish.

If you just need to read data rows, you can configure the schema through the reader parameters dialog when adding the CSV reader to the workspace. e.g.

Reply