Skip to main content
  • EN

Hi all,

My workspace is using the transformer FeatureWriter in SQL Server.

I would like to recover the attribute Operador from my source data.

The attribute Operador was simulated to be the transformer fme_basename.

How can i extract it after the transformer?

Attached my template file.

Thanks

Danilo de Lima

HI @danilo_inovacao,

At this moment the FeatureWriter does not output the features and therefor does not output any attributes.

It has been added as an idea on the Knowledge Board:

https://knowledge.safe.com/idea/23367/add-output-port-to-featurewriter.html

Hi @danilo_inovacao,

 

You could try using the VariableSetter (before the FeatureWriter) and the VariableRetriever (after the FeatureWriter) to pass the attribute across.

You could take a single feature using the Sampler transformer and then aggregate the Summary and single feature after the FeatureWriter transformer using an Aggregator transformer.

This workflow could be a workaround in the interim.

  1. FeatureHolder: Wait for writing completion.
  2. Sampler: Sample a single feature.
  3. AttributeKeeper: Remove all attributes optionally.
  4. FeatureMerger: Merge the summary feature to the source features unconditionally (Join On: 1 to 1).

The FeatureHoder and the Sampler are not essential when there was just a single destination dataset in the FeatureWriter.

Hi @danilo_inovacao,

 

You could try using the VariableSetter (before the FeatureWriter) and the VariableRetriever (after the FeatureWriter) to pass the attribute across.

This didn't work for me - nor did using "Additional Summary Attributes" of the writer. I think I have to use the 1:1 Merge.

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
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.