Skip to main content
Question

Transpose the Name Coumn

  • Jun 24, 2022 11:01 PM UTC
  • 7 replies
  • 60 views

asadamjad
Participant
Forum|alt.badge.img+12

i am trying to Transpose Name fields as a Column and Value are vales

i tried attribute creater and data coming like this its sholud b in one row

7 replies

danilo_fme
Celebrity
Forum|alt.badge.img+58
  • Celebrity
  • Jun 24, 2022 11:49 PM UTC

Hi @asadamjad​ 

 

Could you share the file?

 

 

Thanks in Advance,

Danilo


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jun 25, 2022 12:35 AM UTC

here its is

 

also i am try to do is tester for current year so it will chnage year automaticcly how can i do tht


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jun 25, 2022 10:08 AM UTC

any one


danilo_fme
Celebrity
Forum|alt.badge.img+58
  • Celebrity
  • Jun 25, 2022 11:45 AM UTC

any one

Thanks @asadamjad​ 

 

I used transformers (attached):

 

Attributes 

Thanks in Advance,

Danilo


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jun 25, 2022 12:56 PM UTC

and what about the Current year ?


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jun 25, 2022 1:07 PM UTC

i am getting error will you have any idea why

image"Dropping heterogeneous aggregate feature for the ARCGISPORTALFEATURES Writer, due to feature type allowed geometries restriction"


rahulsharma
Safer
Forum|alt.badge.img+12

i am getting error will you have any idea why

image"Dropping heterogeneous aggregate feature for the ARCGISPORTALFEATURES Writer, due to feature type allowed geometries restriction"

Hi @asadamjad​ 

The error that you are receiving is due to fact that you are attempting to write "fme_aggregate" to a fme_polyline feature (ArcGIS Portal).

You could use geometry filter transformer to fix that or use my workspace below, which should have the expected result (as long as you are writing to a new FeatureService).

In case, you are writing to existing FeatureService, please ensure that incoming attribute names and data type match those on the server.