Skip to main content
Question

Transpose the Name Coumn

  • June 24, 2022
  • 7 replies
  • 14 views

Forum|alt.badge.img+5

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+51
  • Celebrity
  • 2076 replies
  • June 24, 2022

Hi @asadamjad​ 

 

Could you share the file?

 

 

Thanks in Advance,

Danilo


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 25, 2022

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


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 25, 2022

any one


danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2076 replies
  • June 25, 2022

any one

Thanks @asadamjad​ 

 

I used transformers (attached):

 

Attributes 

Thanks in Advance,

Danilo


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 25, 2022

and what about the Current year ?


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 25, 2022

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+10
  • Safer
  • 359 replies
  • June 27, 2022

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.