Transformers

Hey there,Building on the question in this link: https://knowledge.safe.com/questions/70747/finding-the-largest-value-through-multiple-attribu.htmlI want to find the attribute that the max value in the function @max(Value(A), Value(B), Value(C) belonged to. See image below for example:Is there any function in FME that could help me with this? As the title implies, I thought something like @argmax(...) would exist, but I have not found what I am looking for.Thanks in advance

Hi, I have two inputs to a raster mosaicker and would like them to retain the full extends of the combination of the two inputs yet is doesnt seem to: I basically want to have a nice -180,-90,180,90 geotiff. any gaps from the bottom raster input needs to be filled with no data (coming from the top input). Any idea why the RasterMosaicker isnt doing this.Thank you very much for your help in advance.Oliver 

Hi,I have birth days in this format YYYY-MM-DD.I want to calculate their ages.Per exemple, someone born 1950-03-28 would be 70 years old.Not sure how to do that. Any idea?Thanks

Hello Just need some guidance:  I'm currently using SystemCaller + AttributeFilter (0 & 1 for error logging) as a workspace to run a batch file daily which does the following:- Delete existing log files- Create WinScp log file- After setting some variables then log in to SFTP server using WinSCP commands- Upload a file, check its existence on remote server and if exist then upload the respective ".Done" empty file from local server. Exit with Code 0. If failure then abort and always exit with Code 1.- Catch error in case of failure and output it to error.txt (it will tell me which file failed)- Script repeats the same process for the remaining 4 datasets.E-mailer attached to attribute filter 1That's working. I want to:Option 1Use automation to achieve the same result albeit SFTP "External Action" fails to validate the connection and states "Invalid - Path not found". For now I've given up on trying to understand so will skip that option.Opt

hi sirgood daykindly could you confirm if you have software to transfer scanned drawing from JPG to DWG; so i can re modify the drawing. if yes, can you tell me the price of licencing.

Hi, I am trying to read point geometry from a Microsoft SQL Server database and the geometry is displaying in the 'Geometry' attribute like the following example: 'C0FFD20FBC8CCF11ABDE08003601B769D9CEF75331C9F0405EBA490C1EABE44015AE47E17A746140'.I would like this geometry to display in the inspector but am having trouble working out how to do this.I have tried using the 'GeometryExtractor' transformer, first setting the 'Geometry Encoding' to 'FME Binary'. But this results in '3160A883220000000000' being output for every single record in the _geometry attribute and no geometry in the inspector.When I tried setting 'Geometry Encoding' to 'Microsoft SQL Server Binary' I got 'FFFFFFFF' for very record in the _geometry attribute and again no geometry in the inspector.Does anyone know what else I could try? It's my first time reading from Microsoft SQL Server in this way..Thanks!

Hi! I hope you can help with this very basic problem of mine..(although too much to handle for me). So, what I want to do is load data into a sde database. It´s annotations, in coverage format. And what I have seen so far of the result when I only use a simple ”in-data to out-data”-workspace in FME is that the texts don´t end up in a correct way. There are overlaps for example. Then I thought that the only way to do it correctly is with the ”Import Coverage”-tool in ArcGIS. So I created a simple Model Builder model which I then exported to a python script. Below is a screen shot of the model and further down is the script. Script from model export:# Import arcpy moduleimport arcpy # Local variables:tx_24_annotation_tx_24 = "D:\\\\Vagkarta\\\\Shape\\\\vk_24_Sweref_99_TM_shape\\\\vagk\\\\24\\\\tx_24\\\\annotation.tx_24"tx_25_annotation_tx_25 = "D:\\\\Vagkarta\\\\Shape\\\\vk_25_Sweref_99_TM_shape\\\\vagk\\\\25\\\\tx_25\\\\annotation.tx_25"sde_gsd_GNG_vk_tx_anno_modelb

Hello!I have two tables:Table 1:NameBasevalueaaa0bbb0bbb5bbb11ccc0 Table 2:NameValuebbb3bbb8bbb10ccc8 Now I want to get for each feature from table 2 the nearest smaller 'Basevalue' from table 1 compared to the 'Value' of table 2.The Result should look like this:NameValueResultValuebbb30bbb85bbb105ccc80 Any ideas how to do so?GreetingsStefan

Hi, I have a csv file with some coordinates in the following form: Cordinaten gps longitude ; Cordinaten gps latitude 4.438.469 ; 5.186.713 How can I convert this to EPSG:28992? I've already tried the Reprojector, AttribureReprojector and CsmapAttributeReprojector but that didn't help. Thank you in advance.  Greetings, Hans

The shapefile writer (2015 vintage) used to have an option of character encoding - ANSIWhat did this actually mean, iso-8859-1?

Does FME recognise different epochs for WGS84?

Hi, I want to convert ESRI annotation (ESRI geodatabase ArcSDE) to line. (I don't mind if I get the underline insted of the centerline)I've try the EsriAnnotationRenderer transformer and even if the annotation have underline, it only return the text. I've also try the GeometryCoercer transformer but it doesn't work with text.is there a way to do this ? Thanks   

Hi,I would like to break a line into segments and then assign a sequential order attribute starting at the start of the line.For example, in my screenshot, if I break the line into 500m segments, I would like section 1 to go from the start point to 500m, section 2 to go from 500m to 1000m, and so on to the end of the line.I've tried using the iterative snipper and the chopper to break the line but the problem is that they both output the line segments in a random order.Would anyone know how I might do this?Thanks. 

I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?Thank you for any views on this.

 First datasetI created about 1 million lines between 1565 points. These points are locations and the lines are possible routes over a network between the locations. Many of these lines (=routes) overlap each other. This is my first dataset.Second datasetMy second dataset consist also of lines. Part of these lines have an attribute value for attribute 'VWH' = 1. The other lines have a value of 0, VWH = 0.AnalysisWhat I want to do now is to perform an intersection between the first and second dataset. For the second dataset the features are used where VWH = 1. Using the VWH =1 features I want to intersect dataset 1 and attach the VWH value to overlapping lines. See the figure below for the main idea.First I dissolved dataset 2, for VWH =1, into one multipart feature using the LineCombiner followed by the Aggregator. The length of this multipart line feature is 7684 km.Then I used a SpatialFilter to check which features of dataset 1 intersect the multipart feature.Then I tried di

I have a block of text separated by newline characters, e.g:Some TextSome More TextEven More TextPERIOD: 01/01/1990 TO 12/12/2020What I'm attempting to do using regex is grab the entire line of text preceding the row beginning with PERIOD (i.e. "Even More Text"). In an online regex editor, the following expression successfully returns just the line containing "Even More Text":^.*$(?=\\nPERIOD)However, when I attempt to do the same in FME, it returns all lines above PERIOD. It seems as though in online editors the . includes all characters except newlines, whereas in FME it includes them? Is there a way to adjust multiline regex flags (or some other workaround) in FME to get the desired output?

I am new to FME. Is there somewhere I can download basic templates of FME projects? I am currently looking for something to count the number of files / folder in a Windows directory. I assume that is pretty basic, but I have no idea how to start. After I locate a simple template I can take it apart and learn more on how to create my own.Thanks,Dan

Dear all,I need help with task. I have two rasters grom the same place: NIR 1 channel and RGB 3 channel.  I need to replace on RGB raster Red channel with NIR channel and save raster.  How can i do this? Thank you on advance for help

Hey, currently I am using a centerPointReplacer to create points in the middle of cemetery plots (polygons), that meet a certain criteria (they have a photo attached to them). The points are being created in the 'Centre of Gravity Point', it works well, see black dots below, they are all in the middle of our graves:As you can see, the labels of these cemetery plots are covering the dots (or close to), and I am wondering if there is a way I can consistently move these dots to be offset, towards a common narrow end of the polygon? I dont want to use a random spot, as these will not be visually appealing, so I am hoping to move the dots to be along a common side, something like these red dots:If I can achieve this, the labels will all fall back in line and be more visually appealing.To make thinks even more difficult, I should mention that our plots are not all rotated to the same angle, they can face any which way you can think of: Has anyone had any experience doing something li

i have a Problem with the Installing of FME Desktop i have this error " pascal.filippi is a invalid short name files"

I have an odd request. My user has a data set of 758 records. They want to sample 450 of these randomly.I've completed this using a sampler with a random sampling. However, the client wants to add further columns of data to the existing random sample.If I rerun this workspace.I'll generate a new random set of data than before. How do I add a random number to a row, but keep this created number so that when I run the workspace again I get the same sample as before? Thank you!N

  j'ai débuter sur ce workbench mais qui ne marche pas exactement

I have a table with integer values as one of the attributes. I need to add an attribute to represent these values as a percentage of the total of these values like in the table below. have thisneed thisvaluepercentage of total617.64705882411.76470588617.6470588238.82352941225.882352941617.64705882720.58823529  I figured ExpressionEvaluator is correct approach but Im pretty new to fme and cant see how it's done. Any help much would be much appreciated, Rgds

I have an AutoCAD file with many layers and some object data tables (ODT). FME crashes when I try to read it as a Map 3D file. I can't find out what the reason for the crash is, and it reads fine when using a regular AutoCAD reader. When I export out the objects that are just on the layers I need (most of the PR_* layers) I can then read the file as a Map 3D type. I can't tell what is causing FME to crash on the original file. I can't even read the file contents as a Map 3D type.I don't want to have to export out the needed layers all the time, what if the issue is on the needed layers next time, and I am setting up a Server app for users to use and I can't expect them to create separate files all the time.My current FME version is 2020.0.0.1 (20200316 - Build 20202 - WIN64), but I was testing an old AutoCAD file for the Server app, and it ran successfully through an older FME version back in February, but can't now.Can someone tell me what is causing FME to cra

Hi,Is it possible to populate Values of a publish user parameter of type choice at runtime using scripted Python parameter or using any other approach?