Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,684 Posts
  • 50,749 Replies
12684 Posts
sammy
Supporter
sammySupporter
asked in Transformers
Is there a transformer that will calculate the Cumulative Normal Distribution similar to the NORM.DIST() function in Excel?

The Excel function takes the inputs NORM.DIST(x, mean, standard deviation) where x is the value that you want to calculate the cumulative normal distribution for. I intend to use 0 for the mean and 1 for the standard deviation (i.e. the standard normal distribution). I've looked through the StatisticsCalculator as well as the Math Functions in the ExpressionEvaluator but I don't see anything like it in those transformers. This is related to this post where they are attempting to do the inverse: https://community.safe.com/s/question/0D54Q000080hEk3SAE/is-there-a-function-to-calculate-inverse-normal-cumulative-distribution?t=1599138666050 In that post the solution was to use PythonCaller and I am planning to follow that solution but wanted to see if I could use a standard FME transformer to complete this calculation instead.

362
sammy
Supporter
4 years ago
ebygomm
Contributor
ebygommContributor
asked in Transformers
Is there a non-python based solution in FME to convert floats to decimals or vice versa

I don't actually need a solution, but I'm just curious if there's a way to convert a number from a float to a decimal or vice versa in FME without resorting to python. So for example reading some data as a decimal, which is then stored elsewhere as a float and you want to do some change detection and consider56.358400000000003 to equal 56.3584and963.299000000000092 to equal 963.299and56.358499999999999 to equal 56.3585  

100
ebygomm
Contributor
4 years ago
V
vanlam1188
asked in Transformers
Ask for exporting CityGML file

Dear all,I am learning how to export my data to GML. My file has many buildings (including roofs and walls), I separated the roofs and walls for each building using FME.Now, I want to make a CityGML file from this data using FME.It was pretty good when I used the gml_id (in Building class) based on the building's name. The roofs and walls (with gml_parent_id was set as the name of the building) had attached to the correct building (Figure1).But when I inserted and validated this CityGML file into the 3D CityDB software, these were some errors (Figure 2).I tried to ignore gml_id in the Building class (do not change gml_parent_id of the roofs and walls), checking this CityGML file (in the 3D CityDB software) was OK. Unfortunately, the roofs and walls were not attached to the correct buildings (Figure 3).What did I miss and what should I do to solve it?Does anyone have a solution to my problems? I am very grateful if anyone can respond (this took me several days). I am a beginner with

930
V
4 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
How do I write two different file formats to one zip file?

640
LizAtSafe
Safer
4 years ago
jeroen
Contributor
jeroenContributor
asked in Transformers
How to combine multiple rows of one attribute into two attributes based on Excel indention

I'm having some difficulties with an translation of an Excel file that contains a some sort of layered structure and needs to be transformed to a sort of folder/path attribute structure in Excel. The input is as followed:The first problem I encounter is the use of indentation in Excel, it looks like FME does nog recognize this kind of setting/formatting. This issue makes it a lot harder to transform the layered structure of attribute "Naam" to a path structure with an "folder" and "name" attribute. As shown below: I already have a solution separating the steps and merging them back when the structure is OK. I can do this by splitting the steps using the Sampler with a Group By number with sample rate (N) 1 and sample type first N with no randomization. All steps will be in the NotSampled area and can be merges back later based on the number getting the structure from the Sampled part of the flow.  So is there a way to use the indention or anther wa

968
ebygomm
Contributor
4 years ago
L
lmoeller
asked in Transformers
Problems to insert XML formatted text into XML Templater - help would be appreciated

Hello, as the title already implies, I'm trying to merge XML formatted text ("insert") into a similarly ISO19115-1 formatted root template ("template"- see attachments) in a XML Templater feature. The insert (see attachment) is put together in a String concatenator feature from a set of values extracted from a database in a previous stage of the workflow and stored in an attribute named "SCIENTIST_INFORMATION". AFAIK I have two options to achieve what I want:  *Option 1 - plain 'fme:get-attribute()' *:If I use a simple {fme:get-attribute("SCIENTIST_INFORMATION")} the templater replaces XML special chars with their respective protected counterpart (e.g. < with <), rendering the text insert into something I do not intend. Note that I cannot reverse these transformation with a string replacer after the templater, as this also replaces non-XML specific special characters making the resulting XML files invalid.  *Option 2 - &#

7612
L
4 years ago
I
iboates
asked in Transformers
Features extracted from IFC with no identified CRS need to be exported to OBJ - but the output appears stretched along the Z axis

I'm trying to convert various features of an IFC file to OBJ files. I'm able to do the entire transformation up to the point where I save the OBJ files, but it seems that the coordinates are in a projected CRS, evident from the very large X and Y coordinates. I have tried using a CommonLocalReprojector transformer (with a FeatureHolder just before it to make sure the transformation is done relative to the entire feature set):But the models appear stretched when I view them in Blender. Quite drastically. You can see that the doors are much taller than they should be, based on their width to height ratio:The only geographic information I really have from this file is RefLongitude and RefLatitude. But like I said, the coordinates themselves appear as large X and Y values, at least after being read from FME Does anyone have any idea on how I can fix this?

140
sigtill
Contributor
4 years ago
P
pascalmortz
asked in Transformers
Hi folks I'm searching informations for importation of donuts (archipelago) inside GDB format. Up to now, all my donuts are ejected when I try to integrate them. I can do the import in GDB open API or GDB with ESRI licence.

Hi folks I'm searching informations for importation of donuts (archipelago) inside GDB format. Up to now, all my donuts are ejected when I try to integrate them. I can do the import in GDB open API or GDB with ESRI licence.

40
P
4 years ago
morja
Contributor
morjaContributor
asked in Transformers
batch processing multiple dwg-files with differing layernames

Dear community,I am running a conversion from dwg to ifc. the necessary information is placed on a layer which is named differently in each file. I can't find a way to process this automatically, since everytime the workspace-runner brings in a new dwg-file, the attributes are stored on a differenty named layer. Is there a possibilty to read in dwg-files with a filter looking for specification within a layername?Thanks a lot for any hint on this matter.

360
morja
Contributor
4 years ago
R
robe543
asked in Transformers
Have a question about working with multiple geometries exporting from SW 5.2.3 database to a SW 5.1.2 database.

We are using FME 2017.1 to transfer facilities from one company to another going from a SW 5.2.3 database to a SW 5.1.2 database.  I can connect to the SW 5.1.2 Gas_transmission dataset from the SW 5.2.3 session. When setting up my Workspace, I have multiple geometries being exported like gt_line_loop (beg_location, end,location, route_satellite and route_aerial). Iff I have 11 records that I am exporting from SW 5.2.3, I will have 4 sets in the reader (11 per geometry). If I just run a straight tranlastion, I end up 44 gt_line_loop records being inserted into the SW 5.1.2 database. I only want 11 records to be imported/inserted. I did an AttributeCreator and created sworld_geometry{0}.sworld_name for beg_location. I set up another AttributeCreator sworld_geometry{1}.sworld_name for end_location. I crete and Aggregator and do it on ID and Merge Attributes. I run translation and it appears to work fine. I get 11 records with beg_location and end_location populated. I

230
R
4 years ago
peteralstorp
Contributor
peteralstorpContributor
asked in Transformers
Efficient creation of cylinders in Autocad output files?

Hi, you lovely fellow FME-people! I have a question that I have tried in this forum before but I really didn't get help so now I'm trying it again. I use FME to create earth samples speedy and elegantly in an output DWG-file using the DWGStyler. I point out a cylinder block in a template file and then use it in the output REALDWG (after inputting x,y and z and length to each individual sample). The challenge is that I also want to use FME to add tilt and rotation to the block in the output file. Is this possible? Or do you have other suggestions. It is important for me that the geometry can hold attributes and that the output file size is kept to an absolute minimum.

130
peteralstorp
Contributor
4 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
FME cannot write Irish National Grid TM65 coordinate system to Esri formats

Whenever I try to write data in Irish National Grid TM65 (EPSG:29902) to Esri formats, FME writes Irish National Grid TM75 (EPSG: 29903) instead. The only time FME writes the desired coordinate system is if my source data is from an Esri format that is already in TM65.How can I get FME to write the desired coordinate system?

813
daveatsafe
Safer
4 years ago
ciarab
Contributor
ciarabContributor
asked in Transformers
Spike Remover- Analyse by both line Segment values

Hi all, I am working with a dataset that has been generalised and contains ALOT of spikes so I am trying to clean them up. Spike Remover- easy, its a great transformer. However there are spikes I want to keep and those I don't so I have been running a lot of tests on the parameters to get the optimum balance . When you set the parameters you can choose your max angle and length and if the criteria is met then spike is removed. The output shows the spike line segment values 1 & 2 for both sides. It seems to me that if one of the Spike lengths meet that max value criteria then the spike is removed. What I want is to have the option of when both spike lengths meet a criteria then spike is eliminated. This way I have much greater control over what is being removed and allows me to better keep the integrity of the dataset . Am I missing something that I cant do this easily? My Fix--I have put in some rules that basically takes the spike remover outputs for spike_length and tests tha

430
ciarab
Contributor
4 years ago
chau
Contributor
chauContributor
asked in Transformers
Longest path through collection of lines

I have a polygon on which I run a CenterLineReplacer (medial axis). I would like to calculate the longest path spanned by the center lines. How is this possible within FME (preferable within FME 2016) ?

660
bwn
Evangelist
4 years ago
declancoleman1
Contributor
declancoleman1Contributor
asked in Transformers
Querying lists based on attribute values

I am currently looking for a way to query a list to either return all the values that contain the value found in an attribute or return the list index for these values.  I have currently managed to return the list index for the first value in the list to meet this query using a ListSearcher but can't seem to figure out how to return all values. 

1820
declancoleman1
Contributor
4 years ago
R
rlagarde
asked in Transformers
Where is Syntax Highlighting option in advanced text editor ?

Documentation mention 'Syntax Highlighting' as an option in the advanced text editor.Is it possible to set the highlighting scheme to a given language (SQL) from a stringConcatenator transformer? 

80
R
4 years ago
lcw
lcw
asked in Transformers
3D DWG surface to 2D polygon

Hi all, I have a 3D mesh in a DWG file (3D surface of a pavement) and want to convert its footprint to a single polygon in an Esri file gdb polygon feature class (for use in 2D GIS). Can ignore all attribute information. Tried following this post but without luck (I think I need more detailed instructions re settings for each transformer). Anyone here able to help me? Thank you!https://community.safe.com/s/question/0D54Q000080hgjISAQ/turning-a-mesh-into-a-polygon

1570
lcw
4 years ago
O
ozuritah
asked in Transformers
Hi, I converted a raster image with the RasterPaletteGenerator. The new file can be easily filtered in QGIS using the Raster calculator (I only want one value out of the 255). However, I cannot find an equivalent tool in FME. Thanks for your help. Os

I've tried using the raster selector but it always fails (probably because I do not know how to correctly introduce the parameters)I am attaching a print screen of the Raster Calculator from QGIS with the "Expression" I used to filter my raster image. Thanks

40
O
4 years ago
V
vibro004
asked in Transformers
How do I insert shp-data into specific cells in a excel template?

Hi, We are collecting data with Esris Survey 123 and I would like to export the data within the shapefile (table) to specific cells within a excel template. With our gathered data we would like to make excel reports where different data ends up in different single cells within the worksheet. Anyone who has a simple smart solution for this?

120
danilo_fme
Evangelist
4 years ago
bwn
Evangelist
bwnEvangelist
asked in Transformers
FeatureJoiner Probable Bug? - Left Mode NULL'ing Attribute Values from the LHS

Checking this, but surely this has to be a Bug? FeatureJoiner in Left Join Mode and Right Hand Side Conflict Resolution is overwriting LHS Attributes with NULLs where:a) There was no matching Feature on the RHSb) The Attribute Name exists on both the LHS and the RHS I would have thought that for any Left Feature that did not match any Right Feature, there is no "conflict" to resolve and it should exit the Transformer with the same Attribute Values as what it went in with? 

220
bwn
Evangelist
4 years ago
I
iboates
asked in Transformers
How can you export an OBJ file with specific materials on certain features?

I have simply transformed an IFC file to OBJ format, but the default result is that everything has the same flat grey colour. I notice that I can edit the created "materials.mtl" file afterwards to change the different material types, and when I then import the created OBJ file into Blender, I see that the new colours are there. I would like to automate this however, for example making all walls a certain colour, all floors a certain colour, etc., or even changed their colour based on attributes. Is this possible? I see under the OBJ Writer parameters that I can specify a custom Material Library File, but I don't have one to start and I would prefer to simply generate it dynamically, just with the colours for each feature that I specify. How can I do this? I tried using a ColorSetter transformer just after reading some specific feature types but that didn't do anything.

850
I
4 years ago
L
lifeinabox
asked in Transformers
How can I group polygons that are close together?

I'm trying to group together polygons from a single dataset that are in close proximity to one another (0.5 metres). I've used a NeighborFinder (Candidates Only) which gives me a value for distance and have set it to give me a Close Candidates List so that it returns more than one neighbour. However, it is not clear to me how I can tag the features that meet the criteria for belonging to the same group and I have no attribute that I can group by

2480
takashi
Contributor
4 years ago
A
ajc
asked in Transformers
How to get a user parameter input when running workbench as a .bat file.

I have a simple workbench that reads a postgis database and outputs an excel file based on a user parameter in which the user enters a filename that filters the input table into one record. This works fine within FME, however I'd like to create a batch file that runs the workbench from the command line. The problem I have is getting the batch file to prompt for the user parameter. It just runs the workbench with the last parameter I set within FME. I'd like to be able to run the batch file and get the prompt for the parameter in the command line.

3072
bwn
Evangelist
4 years ago
J
jespergrandin
asked in Transformers
Terrain analysis: Slope and total height

I'm trying to analyse an area/DEM with these two criteria:  -Even sloping terrain steeper than 1:20 and total slope height > 5 m.Finding areas with slope of 1:20 (5%) could be done with the slope function. But I can't figure out an easy way to filter these areas to only include areas with slope height over 5 meter. I.e. the total vertical height form start of slope to top should be at least 5 meters.Anyone have any ideas or thoughts on this problem?   Background: The criteria are to identity possible land slide areas (quick clay), so it's already clipped to only include areas of old marine sediments. https://www.ngu.no/en/topic/quick-clay-and-quick-clay-landslides

670
S
4 years ago
O
olesonr
asked in Transformers
I have a shapefile or esri geodatabase file of Appraisal data that I need to join to two different appraisal data tables based on a single field and add the table fields to the original file. What transformer(s) should I use?

I have a shapefile or esri geodatabase file of Appraisal data that I need to join to two different appraisal data tables based on a single field and add the table fields to the original file. What transformer(s) should I use?

90
M
4 years ago

Badge winners

  • Welcome Back
    lukas108has earned the badge Welcome Back
  • 12 Days Participant (2024)
    ahmadrezakarimhas earned the badge 12 Days Participant (2024)
  • Welcome Back
    krishas earned the badge Welcome Back
  • 12 Days Participant (2024)
    victor_xviihas earned the badge 12 Days Participant (2024)
  • Integrate Spatial Data
    metwalyhas earned the badge Integrate Spatial Data
Show all badges
30,186
Posts
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.