Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,712 Replies
10000 Posts
svteshipley
Contributor
svteshipleyContributor
asked in Transformers
How do you dynamically remove attributes of missing columns?

I am building transformations that send data to Azure Table Storage. When the attribute value is missing there is a blank string inserted into the table. Due to the nature of the feature, there will only be one row of data but different columns may have missing or null values. These values we do not want written to the table. I have tried using Python and NullAttributeMappers, but these still leave the <missing> value which is causing issues. Is there a way to dynamically remove these columns? The reason for wanting to remove the attribute columns before the Azure Table Storage writer is that "Automatic" Attribute definition appears to be required in order to dynamically pass different columns to Azure.

4306
svteshipley
Contributor
checcosisani
Contributor
checcosisaniContributor
asked in Transformers
css selector for span

Hi i need to extract only text inside spanI used this css string for this website http://sac5.halleysac.it/c038007/mc/mc_p_ricerca.php?multiente=c038007&pag=0tbody > tr:nth-child(-n+20) > td.break-all   thxFrancesco

640
ebygomm
Influencer
marcyeranos
Contributor
marcyeranosContributor
asked in Transformers
Hello, I am new in the FME community but with a great experience of FME Desktop which I would like to share with you. I don't know and I do not understand how to make and publish the article on the page. Could you help me, please?

Hello, I am new in the FME community but with a great experience of FME Desktop which I would like to share with you. I don't know and I do not understand how to make and publish the article on the page. Could you help me, please?

130
marcyeranos
Contributor
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Transformers
Best way to polyogns from raster where polyogns represent a range of values (elevations)?

I have a single band raster (DEM raster) I want to create polygons which represent ranges. For example I have pixels with a range from 100 - 500 and I want to create polygons where values are in the range 100-105, or 105-110. I've tried to contourGenerator and building areas from those but contours aren't close so it's not really an option. RasterToPolygonCoercer I think would work but I need to first get my raster values to be grouped by the interval - this is where I'm having trouble. any ideas?

170
M
lau
lau
asked in Transformers
Converting Autocad dimensions to ArcGIS Pro

I am able to convert Autocad dimensions to “Arcmap” dimensions following the response of @Mark Stoakes​  : https://community.safe.com/s/question/0D54Q000080hgppSAA/migrating-dimensions-from-autocad-to-esriHowever if I try to write dimensions to a geodatabase with an ArcGIS Pro geodatabase template, I get this error : |FATAL |GEODATABASE_FILE writer: An unknown exception occurredI read that is not yet supported to read “ArcGIS Pro dimensions” with FME : https://community.safe.com/s/question/0D54Q00008wRTK3SAO/getting-error-like-unable-to-convert-row-to-dimensionfeature-while-reading-a-dimesions-fileIs it also impossible to write dimensions to an esri geodatabase with an ArcGIS Pro geodatabase template ? You’ll find my fmwt in attachment.Any advices is welcome 😊Laurent

1000
danminneyatsaf
Safer
K
kjmcpherson
asked in Transformers
Date Transformation from string format: Month (text, full name), Day (number, no leading 0s), Year (number).

I'm working with a date field that needs to be converted from a text string giving the format as described in my title (e.g. October 1, 2022). I've found a lot of documentation on the DateTimeConverter, however none of the formats on the documentation seem to match up with my date format. This seems like a simple solution that I'm missing, any help is appreciated!

710
M
ccrutchf
Participant
ccrutchfParticipant
asked in Transformers
Is there a Transformer to eliminate polygon indentations?

If so, what parameter settings would accomplish something like the attached example?

60
david_r
Celebrity
S
sibe
asked in Transformers
I have many polyline Z features in the same feature class. I have modified them in such a way they are located at their own standard depth, relative to the surface level. How can I connect the last vertex at the same depth of connecting lines?

I would like to modifiy the last vertex of each line feature, if the lines intersect, to copy the depth so that also the connection is made in Z-coordinates. Based on an attribute field there should be determined if the Z-value should be copied or overwritten of it's connecting neighbour. 

100
tomfriedl
Contributor
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in Transformers
Sequence of data

Hi. Today's second question, I'm glad that this forum exists :) I'm sending the "example" file in the attachment. I would need advice on a transformer where I could implement a sequence of individual segments. I have an idea, but I don't know how to implement it in WS. StartPoint and EndPOint is one segment. I need to determine the correct order of the segments. To get the correct order, I need to determine the first and last point - the value of the first point must meet the condition of occurrence in "startpoint" and at the same time it must occur only once ( A1 ). If I manage to determine the first segment, I need to further apply that the endpoint value of the first segment ( A2 ) is the starting value ( startpoint ) of the following segment. This way the correct sequence will be connected. Some ideas? 

470
fmesafe.podpora
Contributor
limo
Supporter
limoSupporter
asked in Transformers
Is it possible to zip the output from FeatureWriter?

Hi, I have to zip the output from the featurewriter.The standard writer has the option to zip the output. Is this also possible with transformer "FeatureWriter"? I have not found anything about it. I need FeatureWriter because my process will go on after writing! 

680
limo
Supporter
S
sjolster31
asked in Transformers
How do I rename field names in a GDB that has many features with each feature having a variety of fields?

I have a GDB containing point, line, and polygon feature classes. I would like to setup an attribute manager or schema mapper that allows me to change a field name to whatever I please. I can place an attribute mapper on every single feature class from the reader but that will take forever. How do I read in all the feature classes, see all the current field names, be able to change said field names, keep all the attribution in those fields, and write the same data out but with new field names? Some screen shots are below of my GDB. Note, this is something I would like to be able to do to many GDBs down the road that should have identical field names.

1920
M
J
jonahdpmiller
asked in Transformers
Details on "Attribute Name" parameter type configuration?

I've been trying to find explanations for the properties saved under "Attribute Name Configuration" for an "Attribute Name" parameter type and haven't been able to locate anything! This is specifically regarding how "Format Attributes," "User Attributes," and (especially) "Filter Attributes By Port" are handled, given that they have not worked the way I expected based on name alone. Is there additional documentation on these parameter settings anywhere, or should I try to communicate with technical support directly for info? Thanks!

1030
kailinatsafe
Safer
alfons
Contributor
alfonsContributor
asked in Transformers
Indexing chopped line segments

Hello,  for calculations on line segments I divide a line into its individual segments between two vertices (2-point line) using the transformer "Chopper". For a further processing step I need the number of the segment within the total line. This means that if my line consists of 11 vertices, I have 10 line segments. The first line segment should start with the element ID 0. I have tried to do this with a counter, but without success. For this reason, I would like to ask how I can solve this elegantly. Thanks a lot

190
alfons
Contributor
mohamdwassouf
mohamdwassouf
asked in Transformers
I tried to create a storyboard on fmedesktop as in the attached file, but I need something to be able to transfer the location information. What is this thing?

WelcomeI hope you can help me find a solution to this problemI really need help to solve this problemIn the attached form, I have successfully exported the data from the Revit program to the ifc formatThe data has a geographical reference specified by coordinates on a map in the RiftI want to transfer this data to citygml format while keeping the site coordinatesI tried to create a storyboard on fmedesktop as in the attached file, but I need something to be able to transfer the location information. What is this thing?

80
muzhnasto
Contributor
B
borko_k
asked in Transformers
How to extend building sections to the minimum width or how to generalize complicated polygons? Unfortunately, Generalizer didn't give satisfactory results.

Hi, I'm working with building polygons. And I'd like to generalize them based on the specific ordinance. Unfortunately, Generalizer didn't give satisfactory results, so I decided to use the possibility of ArcMap, so I applied the arcpy script in PythonCaller - with Simplify Building algorithm. Much of the dataset has been generalized quite correctly. But some of the polygons have fragments whose width is narrower than the minimum value specified in the regulation. I mean buildings with complex geometry (see pic. below). And my question is - do you know any idea, how to extend only these narrow fragments using FME or arcpy? The solution should be universal, because, I need to transform a lot of buildings. I tried to use Generalizer or convert the polygon into lines, calculate length and extend this line, but without any satisfactory results.  I am working on FME Desktop 2021.2.5 and ArcMap 10.6 - without any chance to upgrade FME Desktop or ArcMap.

220
muzhnasto
Contributor
R
rowdy
asked in Transformers
GeometryPropertyExtractor can't get properties?

I'm trying to isolate circle polys with a -360 Sweep Angle below but can't get any traits from the GeometryPropertyExtractor? Anyone know the settings and/or query to use here? IFMEPolygon  Linear Boundary No  Convex Yes  Orientation Right Hand Rule  Boundary: IFMEPath (1 Segment)    Closed Closed In 2D    Segment 0: IFMEArc Arc By 3 Points      Closed Closed In 2D      CW/CCW Clockwise      (Circle) Radius 49.999964742921485      Start Point 561532.7739287984, 5274944.139919876      Mid Point 561532.7739375194, 5274844.139990389      End Point 561532.7739287984, 5274944.139919876      Rotation (Degrees CCW) 0      Start Angle (Degrees CCW) 90.00000499684722      Sweep Angle (Degrees CCW) -360

640
virtualcitymatt
Celebrity
saravanakumar
Supporter
saravanakumarSupporter
asked in Transformers
How to reduce vertex count in line feature?

Hi all, Is there any transformer to reduce the no of vertex in line feature?I am using autocad data dwg format. there is large no of vertex in a line feature which you can able to see below image. Is it possible to reduce the number of vertex? and I tried with line combiner Its not reducing no of vertex.thanks ,saravanakumar.

1570
saravanakumar
Supporter
fmelizard
Safer
fmelizardSafer
asked in Transformers
FME workbench isn't scaling/rendering correctly on my PC.

The GUI (icons, buttons, menus, text, etc.) in FME workbench isn't scaling/rendering correctly on my PC. Some elements are relatively large while others are very small. Is there a way to fix this?

2500
T
checcosisani
Contributor
checcosisaniContributor
asked in Transformers
Hi I need to remove new line in the result of my HTML extraction S.P. n. 1, S.P. n. 30, S.P. n. 245 the result must be S.P. n. 1, S.P. n. 30, S.P. n. 245 thx Francesco

Hi I need to remove new line in the result of my HTML extraction S.P. n. 1, S.P. n. 30, S.P. n. 245 the result must be S.P. n. 1, S.P. n. 30, S.P. n. 245 thx Francesco

60
checcosisani
Contributor
T
tobiasrydlinge1
asked in Transformers
How can I create a weighted sum raster with vector files as input?

I want to create a raster image with the sum of weighted input of vector polygon layers. I have many vector polygons. Each polygon should first be transformed to a raster and then given a weight/raster cell value (1-3, background value should be null or 0).

500
M
nea
Contributor
neaContributor
asked in Transformers
Creating a user parameter

I'm trying to create a user parameter that consists of the filepath, 'Output', and filename to be used in the writer

3070
nea
Contributor
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in Transformers
Finall editing

Hi. I am asking for advice on final editing. The qus1 file is the current FME output. In the StartpointDesignator column, I need to remove duplicate values and output them to the CSV output in the format see the "vzor" file.Thank you

260
fmesafe.podpora
Contributor
S
shreyas.udupa
asked in Transformers
How to dynamically load a query and create a table using query results

I'm trying to pass the sql query dynamically through the webhook url and then execute the query and generate a table using the query results.I have tried using the SQLCreatorProblem is, It is not able to expose the attributes automatically from the SQL query if passed dynamically.Is there any other transformers which would help me execute this?

1490
ctredinnick
Supporter
S
sibe
asked in Transformers
How to preserve existing z values in a polyline featureclass using the surfacedraper transformation?

I would like to insert new z values in a polyline feature using the surfacedraper while maintaning the existing z values. A feature can have mutiple vertices with and without z values or a combination.

290
S
mathiku
Supporter
mathikuSupporter
asked in Transformers
Spatial relation seems to struggle with boundary coordinates

An overlay analysis between some polygons and a few lines has turned into quite the ordeal.I hope the supplied workspace and data is self-explanatory.In it there is four tests that yield different results. I start with clipping the lines with the polygons followed by a spatial relator intended on creating a list of references. I would expect that relator would find a relation between all lines since they can only be INSIDE. But more than half fails. To test the reason I run it through an Intersector and measure the distance from intersection node to polygon mask. I guess that is supposed to be 0, but 3 of 20 return a value larger than 0 - meaning that the intersectionnode is not in the intersection.    

110
mathiku
Supporter

Badge Winners

Show all badges

Community Stats

31,807
Posts
120,816
Replies
39,433
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.