Transformers

I have the following table. labelareacodecountA100114A10023A10032A10188A10291B100164B10022B10041B101268B102121C100137C10024C10042C101493C10217 I want to pivot the table. So I get the following result. RijlabelsABC1018826849310291121171001146437100232410032  1004 12 I tried the AttributePivoter (and also the AttributeTransposer) but I can't get this to work. I don't understand what I am doing wrong. Hope someone can help me with this issue!Thanks! 

I'm trying to update a large file with many attributes. The original file's attribute names followed a specific nomenclature with 4 alphanumeric chars, then an 'X', then followed by 3 digits. An example:ZA01X001The new file now has the 'X' stipped out, so the new example is:ZA01001My problem is that my workflow uses an AttributeManager to rename about 80 different attribute names from a separate lookup table that corresponds the attribute coded name to a variable name like so:ZA01001 = Total Population with Medicaid CoverageSo this new file is throwing off my AttributeManager with the 'X' now gone. My question is, how can I use the BulkAttributeRenamer or other method to easily insert an 'X' into the 4th position of all attribute names?

I have the following table:Borehole_IDFinal_Depth243446575523452.5 I need to generate incremental Start/End (start from 0) ranges table based on unique values in Borehole_ID and the end values from Final_Depth. Something similar to table as below..Borehole_IDFinal_Depth_RoundDownFinal_Depth_RoundUp243401243412243423243434657501657512657523657534657545234501234512234523 @takashi

I created a PointOnAreaOverlayer workflow that creates a grid of x-y points and a circle area. When I run the PointOnOverlayer I get the expected results plus one additional point outside the area. Why does the workflow return the additional point that is outside the area? --I can seem to attach files. I will do so after posting

Hello Team, I have workbench with python start script, It was working fine with python compatibility Python27 in desktop 2015. Now I have upgraded with desktop 2019 and python compatibility changed to Python3.7 which is throwing syntax error and it could not able to initialize the arcobjects. Could somebody help me to get out of this issue. Thank...

Lets say I have a polyline that covers a road, and on that road there are multiple stoppage points represented by another layer (point layer), how can I segment that 1 polyline to autocut to the closest point in its vicinity? (the points are not always overlayed exactly ontop of the polyline). Here is an example So for this 1 polyline I am trying to get 11 pollines where it would break at each dot.

HiI have a workbench looking at a json feed: https://niord.dma.dk/rest/public/v1/messages?lang=dk&domain=niord-nmThe feed contains attachments for some of the features, with a column specifying a link to the location of the attachment (PNG file typically):I would like to populate a field with this url, so that I can sent it to correxponding features in a SDE database. i tried to use AttributeExposer and AttributeCreator to extract the link to a new coloumn, but this seems impossible as the coloumns with the attachment information is not available in the list of attributes to expose/create (should be between areas and charts):How can I extract the information from attachments coloumns to an attribute in FME then?Here is an example of one of the attachment files:https://niord.dma.dk/rest/repo/file/messages/e/f0/ef03d235-70af-44e9-8a20-8c506534abfe/80/Overview%20with%20national%20measures_5.png

Hi,I've just updated to the new FME version (2019.1) and I am experimenting some stranger issues with the Sorter Transformer as you can show on the image bellow:  However, If I start the process with a SQLCreator transformer or put an AttributeKeeper before Sorter, I won't get any issue.I've never got this error on previous FME versions. Any ideas? Thanks in advance. Regards. 

I use FeatureHolder to control the dataflow between FeatureWriters in order avoid blocking situations because the FeatureWriters write to the same database. So far so good.Confusion started when the FeatureHolder seemed to let features pass unexpectedly.Turns out the reason for this were disabled connections upstream during various trials in testing phase.EDIT March 26: the italic writing was the original text but is NOT correct.Solution to get predictable behaviour was to disable transformers instead of connections.Conclusion: A disabled transformer upstream of a FeatureHolder will cause the FeatureHolder to stop everything, which is what I expected.A disabled connection upstream of a FeatureHolder (no matter how far away) will cause the FeatureHolder to let everything through, which leads to uncontrollable behaviour from the testers point of view.Any objections to these findings ? Is this intended behaviour, or is it a bug ?EDIT: March 26: new revised textFeatureHolder is not usable

Hello, I try to count points within polygons. The problem is that my selection of points does not take into account all the polygons but is cut at the intersection of the two polygons. I tried everything in the options of the spatial Filter but I can't find the solution.   In the screenshot, I'm testing attribute 60 Thank you for your help

Hello all,fear i'm out of my depth here. Trying to build a workflow to manage some maintenance for gardens ect and the differing levels of gardens and grass obviously have differing maintenance frequencies.For existing areas eg for the 8 weekly maintenance areas, their due date would come up and that would trigger the workspace to create centroids (ie points) based on site name (if sharing the same site) and then update the assignments layer for arcgis workforce. Now what im struggling with would be how id trigger those updates to the assignment layer depending on which maintenance schedule had elapsed that day? Just to give you an idea some are weekly, fortnightly, monthly ect. James

I'm aiming to compare the values of multiple tables from two different data sources with FME. I've already prepared two tables, that list all values from either data source.The 'left data source', consisting of two tables (Fruit and Vegetable) and their values over various columns:IdLeftTableNameLeftColumnNameLeftValue1FruitNameApple1FruitColorRed1FruitKcal522FruitNameBanana2FruitColorYellow2FruitKcal893VegetableNameCarrot3VegetableColorOrange3VegetableShapePointy The 'right data source', consisting of two tables (FRUITS and VEGETABLES) and their values over various columns:IdRightTableNameRightColumnNameRightValue1FRUITSDESCRIPTIONApple1FRUITSCOLORYellow1FRUITSCALORIES522FRUITSDESCRIPTIONBanana2FRUITSCOLORYellow2FRUITSCALORIES903VEGETABLESDESCRIPTIONCarrot3VEGETABLESCOLOROrange3VEGETABLESSHAPEPointy The tables and columns of both data sources can be related using the following mapping:LeftTableNameLeftColumnNameRightTableNameRightColumnNameFruitNameFRUITSDESCRI

Hi Im experiencing issues trying to use GML in XMLTemplater.  Code:  {fme:get-xml-attribute("_conc")}  Works fine for  _conc = <xml:Point> ....... </xml:Point> Prints nothing for _conc = <gml:Point> ...... </gml:Point>  Perhaps this not supposed to work? In that cas is there a workaround?  Best regards

Hi list.I'm currently trying to generate a composite XML using XmlTemplater.One of the details is that tags without text value must not be output at all.I tried to utilize the following expression (from the help page):{ if( {fme:has-attribute("mailadresse")} )then <ler:mailadresse>{fme:get-attribute("mailadresse")}</ler:mailadresse>else ()}My expectation (for "else") is that output is only generated if an attribute value is present.Much to my surprise, "<ler:mailadresse/>" is output instead, even though the attribute value in question is <null>.Can anyone share how to tweak the expression, so "else" produces absolutely no output ?And yes, the presence of the "else" part seems to be mandatory.Using 2020.0

Hello,Within the ChartGenerator is there any way I can have a second line in the Title, but with a smaller font size? i.e. like a sub heading.In fact having the ability to dynamically adjust the font of text within text elements in FME would be great. This way I could just add a return in the text editor to give me text on a new line and then wrap any text in a set of parameters that overwrite the font settings in the transformer. In my case it would be the same font, but a smaller size.Also, is it possible to add labels to the point markers or a selection of the point markers in a line type plot?Thanks

I hope you are doing well during these different times. I have some point data that represents addresses. Sometimes one address (123 Main St) can have more than one feature because one represents the building and one the parcel. I have used the Matcher, matching on the address string field. Now, I have a _match_id that is unique for each different address. Now I want to filter the data. Ex: For each unique _match_id value, filter out features that are an address_type of Building. How do you suggest doing this? 

Hello,  I am having problems modifying existing appearances on geometry.  I have an FBX file (no textures, only mesh colors) that i want to get the appearance from, do some changes on the diffuse, emissive, ambient and so on. This I have managed with an AppearanceExtractor node then do the changes in from a pythonCaller.  Now the problem I have is I don´t know how to append the newly modified appearances to the geometry again. I guess i should use the AppearenceSetter node, but I don´t know how to get an attribute from the geometry to join on.   Does anyone know the solution to this problem?

I am trying to create multiple attributes based on the string in a single attribute. E.g. I have a series of features with percentages for each. I want to create an attribute for each feature. There may be multiple features with the same name.  This is the example source Week NoUser% 1Tim151Sam252Tim122Sam193Tim93Sam104Tim254Sam15Tim145Sam726Tim526Sam3 And this is what I want it to output  Week 1 %Week 2 %Week 3 %Week 4 %Week 5 %Week 6 %Tim15129251452Sam2519101723 I have tried BulkAttributeRenamer and cant get it to work. This is how I tried it (one of many attempts).  any help on this would be great.ThanksSeb

For years I have been using a small helper function to log in both FME Desktop Log Window and Logfile (and FME Server):def myLogger(string):    print(string)    with open(fme.logFileName,"a") as f:        f.write("{}\n".format(string))With this, my log messages were written to the Logfile and when executed in FME Desktop Workbench also visible in the log window.Now, FME 2018.1 and newer redirect stdout to info logging and stderr to warn logging in the FME session.But in the Shutdown Script the FME Session has already been terminated.Is there any way to put info into the FME Desktop Log Window from a Python Shutdown Script?

Hi, I'm very very new to this so apologies if the question is stupid or posted in the wrong place. I'm trying to learn FME usuing the online resources and this forum as this is the first work chance I've had to do it and liking it so far. I have researched my question already but didn't find relevant recent answers (unless of course I have missed them) I'm trying to generate a Clip and Ship type of service. So I'm starting with the Austin download example which will give be a great foundation for my requirements, however I'm falling over on the first hurdle. The current user parameter list for austindownload is pre configured as a text comma separated list .... my potential requirements is a for a more dynamic list which would be controlled by a table in Oracle (sde) with a number of attributes in the table that I envisage as being required to delivery additional components related to the dataset. So I have a worksbench that connects to a gdb and based o

If you provide proj4 parameters string to PROJReprojector with extra spaces in "towgs84" clause - transliation finish with error:PROJ: proj_create: Non numerical value in towgs84 clauseReprojector: Invalid reprojection parametersFME version 2020.0

We want to confirm the availability of the 60 day trial for a pilot project we are working on.

I know there are already posts about this, but couldn't find much info about it.I have a column in csv with multiple fields and values in the same column:col1 { "21" : 80.0, "81" : null, "21" : 100.0, "21" : 60.0 } { "21" : 60.0, "21" : 80.0, "81" : null, "21" : 80.0, "21" : 100.0, "21" : 100.0, "21" : 60.0 }  Representation-21- max speed81- max weightThe occurrence of fields:1st time- Car, 2nd time- Bus, 3rd time-TruckMax Speed (Car) Max Weight(Car) Max Speed (Bus) Max Speed (Truck) Max Speed(D Truck) Max Speed (B Truck) 80 null 100 60 null null 60 null 80 100 100 100  Attaching the csv. I am able to use AttribuleSplitter, SubstringExtractor and putting them in fields, but the values are not in uniformity. Any suggestions?Thanks in advance.

Want to Trace downstream of Electrical Network

Hi I have about 100 feature classes in SDE to migrate to new DB. Following initial load, I would like to only process change only updates on a hourly basis. Some tables have over 4 million recordsHas anyone have experience of using ChangeDetector/ UpdateDetector in FME. How is the performance like. Any best practice suggestion regarding reading/writing 100 feature classes?The new DB is on different SDE/SQL Server version, hence I would prefer to use FME rather than SQL replication for this.