Skip to main content
Question

Create schema for CSV file

  • March 15, 2019
  • 1 reply
  • 74 views

nedwaterman
Contributor
Forum|alt.badge.img+9

 

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • 7843 replies
  • March 15, 2019

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.