Skip to main content
  • EN

Hi, I have the following csv sheet created with FME

That is not exactly what I want. I would like to see the following format:

The third column is empty, and for the last 4 columns only 1 row is needed. How can I achieve that? The values in the last 4 columns are purely inserted in the user interface at the start, not more than that.

Below is the part of FME:

The user parameters of the writer  are as follows:

Any tips?

Hi ​@sparks ,

For the last four columns, you can write the parameter values into only the first row with:

  1. Insert Sampler before the CSV writer feature type to select the first feature (Sampling Rate (N): 1, Sampling Type: First N Features).
  2. Add ParameterFetcher and connect it to the Sampled port of the Sampler to get the four parameter values and assign them to the destination four attributes (Assetsoort_A, Soort termjin A, ...) .
  3. Send all the features from the ParameterFetcher and NotSampled port of the Sampler to the writer feature type.
  4. In User Attributes tab, the CSV writer feature type, remove values from the four columns.

Community Stats

31,838
Posts
120,908
Replies
39,468
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.