Skip to main content
Question

Feature Writer with CSV and >100 files?


Forum|alt.badge.img

I am trying to split a very large csv-file for further processing. I currently read the input, count the features, divide by a set number of max lines, round to integer and use this attribute as a filename to write new files with a feature writer.

Somehow, the attribute is calculated correctly but using it as a filename results in a maximum number of 100 files being written. The feature writer then starts overwriting the first file again.

Am I missing something?

3 replies

david_r
Evangelist
  • June 23, 2020

There are several possible solutions, but the easiest is perhaps to simply use the GroupCounter from the FME Hub: https://hub.safe.com/publishers/lars-de-vries/transformers/groupcounter

You can then use the resulting attribute _group for the fanout.


Forum|alt.badge.img
  • Author
  • June 23, 2020
david_r wrote:

There are several possible solutions, but the easiest is perhaps to simply use the GroupCounter from the FME Hub: https://hub.safe.com/publishers/lars-de-vries/transformers/groupcounter

You can then use the resulting attribute _group for the fanout.

The attribute is calculated correctly. Only the fanout doesn't work within the featurewriter.


david_r
Evangelist
  • June 23, 2020
jakob wrote:

The attribute is calculated correctly. Only the fanout doesn't work within the featurewriter.

That is surprising and unexpected. Can you show us some screenshots of how the fanout is configured? And have you double-checked that the fanout value is indeed correct for values > 99?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings