Transformers

I have a column of health conditions for individual patients.Often patients have multiple health conditions. If they have more than one, then the conditions are seperated by a ; (Some patients have up to 5 separate conditions)I need to find out how often individual health conditions feature. ie how many times is "Arthritis" listed as one of the health conditions? I've used the Attribute Splitter, using the ; as the delimiter. This creates a list of the health conditions, I've named the list "Health_Conditions". I now want to find out the number of times each health condition appears in the list / exposed values of the list. ie how many times does eg "Arthritis" appear? And how many times does "Diabetes" appear?  Note: From the screen shots below you can see health conditions can appear in any of the exposed value lists{} I've tried Statistics Calculator, Counter, ListHistogrammer but can't get the result I am looking for. Many tha

Hi,When using a 'File/Folder/URL' public parameter inside a GroupBox with Conditional Visibility of the user parameters, it doesn't seem to enable file upload within a published FlowApp. When you're editing the Workspace App in Flow the expected behaviour is working with a display window which allows you to upload a file. Also when running the workspace in Flow it works. Only doesn't work in a published app. Is this a known issue of FME Flow 2023.1.2 and Form 2023.1.2.0?Previous post and reply by Kelvin Jenkins seem to highlight this. Thanks.

what is the easiest way to automate adding previously created domains to a new FGDB in FME ? or is it possible to manually recreate them in AttributeManager (similar to how you can create alias') ? similar to how it is in ARCPRO show below 

Hi, I can read an arcgis online feature service using fme AGO reader. The globalids all have a curly brackets in the inspector. Is there a way to write the feature to a new table without the curly brackets. Curly brackets are messing things up when using globalids in url links. thanks

Hi all, I want to save a step in my workspace by using AttributeManager to generate an ESRI Global ID (aka, a UUID with "{}" in the string value) with the @UUID() function. I do this with the @TImestamp() function, but I don't quite understand the syntax...  @UUID(SIMPLE,UUID_FORMAT,[GLOBAL_ID|UUID_ONLY])  I've tried a bunch of different options, but how would I skip the "SIMPLE,UUID_FORMAT," options? All I want to stipulate is the GLOBAL_ID option.... thanks!

I'm trying to draw a box given four vertex creators, I couldn't get the polygon section to work from line builder - any tips on making this more efficient, I feel like four line builders is not the most elegant solution (although it works.) Thank you. 

Hi,When working with visibility of published parameters through conditions in Form, is it possible to have multiple test clauses for a parameter?Similar to the Test transformer with logic "if", "or".Thanks!

If I run each reader individually (one-at-a-time) then I get correct output from each of the readers. If I choose 'Run Entire Workspace' then one reader only processes one record and the other reader processes normally. All feature classes are in the same file geodatabase. Any ideas why 'Run Entire Workspace' doesn't give the expected results?Thank you.

Hello,Is there a good approach to extrude only outer edges from top image? Images below extrudes all faces (internal as well) but am only interested in extruding (external faces). Basically thinking of top image as a building roof, altough it's a terrain and extruding to "walls". On the lowest image I used PlanarityFilter to try filter faces at bottom but doesn't feel like a good approach.Thanks.   

I try to convert the attached dataset into ESRI GeoDatabase It failed following message. But there is not duplicated fields in my datasetThanks 

The feature count is 0 after conversion from GML.There is no error. I got warning only. The attached are dataset and log

From my tests it seems apparent that the ShortestPathFinder only works correctly in 2D. The route will snap between different levels even through the network is noded correctly. Has anyone had any success applying a shortest path algorithm to a complex 3D network, for example a building containing multiple floors with overlapping routes/nodes in 2D?

I am trying to convert a custom S-57 format into a file GDB. I can upload the file if needed.

Hi All, I've had something that I've been wondering about for a while.In this example, I'm reading 11 SQL tables in using a feature reader and all of them contain a WKB column. I need to run these through a geometry replacer to assign their geometry.   I tried running them all through a single geometry replacer, and using an attribute filter to return them into their own streams, but running them all through one transformer ruins the schema. Is there anyway to return the original schema? Or do I need to create 11 different geometry replacers and keep each stream 'seperate'? I'm aware that I can define the output attribute definition for each layer but I wanted to know if there was a less 'manual way. Many thanks, Sam

Hello  It says Translation is Successful, but i dont't see the any out , am i doing something horribly wrong or missing some setup ?  Python Caller  import fmeimport fmeobjectsimport numpy as np class FeatureProcessor(object): def __init__(self):pass      def input(self, feature):           def myfunction(L, F, DX, DY, DZ):       DLF = [0,0,-1]       ULF = [0,0,1]       NLF = [0,1,0]       SLF = [0,-1,0]       ELF = [1,0,0]       WLF = [-1,0,0]             if L == "D":         UAP = DLF       elif L == "U":         UAP = ULF       elif L == "N":         UAP = NLF       elif L == "S":         UAP = SLF       elif L == "E":         UAP = ELF       elif L == "W":         UAP = WLF               if F == "D":         FAP = DLF       elif F == "U":         FAP = ULF       elif F == "N":         FAP = NLF       elif F == "S":         FAP = SLF       elif F == "E":         FAP = ELF       elif F == "W":         FAP = WLF                 VAP = np.cross(FAP, UAP)       DU,DV,DN = np.linalg.inv(n

Hello , i habe two source data first source data contains attribute calledid 3839464 3937793837390389304——second source data contains cable network attribute 3839464-hsld282-owuwpw37394-283994383894-Jagdhorn-2839463389304-hdjskd-dddjf how could I search at attribute cable network by using id attribute ? i would like to know if any of id value exist in cable network attribute .fme 2021 thanks in advance

Dear fellow FME users, I am trying to delve a bit into the Rcaller in combination with asking data from a website (CBS). I have a bit of R experience, but not so much with the Rcaller. With Rstudio the code works without a problem, however I don't manage to succeed in FME desktop 2022.2.1.0I am running the code below. I am aware that you need to adjust the R code a bit before making it work in FME desktop, so I was wondering whether I have to adjust the current code. In my case the Rcaller is running and it seems like it's doing nothing or stuck. I therefore I assume that the code is probably not working. Can someone else test and see how I have to adjust the current code?  Furthermore I am looking for blog posts that delve into the Rcaller. I would like to learn more about the rcaller and make myself a bit more proficient.# Run once:install.packages("cbsodataR") library(cbsodataR) # Downloading table listtoc <- cbs_get_toc()head(toc) # Downloading entire dataset (can take up to 30s

example of text string Bike :SS Lightning;NDIS #:;Prefname:Jacob;GEOG CODE:46429;Referred By: Newsletter;NDIS Planner:;Continual EOI:;Customer Type:46021;Date of Birth:;RidingCommunity:Short stature;Support Co ordinator:;notification_billing:1;notification_reports:1;Allied Health Company:;Allied Health Contact:;Allied Health Position:;notification_marketing:1 not all features contain all of the field names. I want to end up with columns Bike, NDIS#, GEOG COde etc and the data for each attribute in a excel spreadsheet. Thanks

Looking at article Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) I am trying to run the same directly to an AGOL hosted feature layer. I have created the requisite "_alias" field to match those that I need alias values for, but no dice. Also tried adding the same fields (matching the attribute manager) to the writer attributes (manual setting) but the result simply created additional fields with the "_alias" suffix. Is this possible with this writer?

I have a workspace that was just pulling data and joining schema from two feature classes from an enterprise geodatabase. Then, we had a business need to add two new fields to the output feature class. (I cannot add them to the input feature class). Now, when I run the workspace, it overwrites the edits to those two new fields. Does anyone have suggestions on how to set this up in FME so that the two new fields (flagged and flagged description) aren't overwritten? Here is a screenshot of the workspace. Thanks!

Working Key: 1472_3_81445Not Working Key: 1472_E2b_81445 

Python = np.cross(XYZ, ABC) ????

I am working on a web application project and will like to include energy consumption, inlet flow and outlet flow, temperature readings visualizations in the 3d model buildings in Cesium

The firs one query is  And the second one is Then I need to do a join with this second query and create a list with the results.I dont know if with the SQL Executor transformer I can replicate this two querys.  Any idea? Thanks

Long time listener, first time caller.Newish to FME and was attempting to use a user parameter for the first time to allow the user to input the number of days they need to pull data. I have the parameter and the initial formula working fine. DaysPulled is my user parameter: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P$(DaysPulled)D),%Y%m%d) The problem I'm running into is later on in the flow I need to use that user input and add a number to it, effectively turning the user parameter into DaysPulled +1 and DaysPulled+2. I've been beating my head against the wall trying to modify DatePulled using add, sum, +1, etc and can't find the right format to get what I need. Example of failed attempt.@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P@add(1,$(DaysPulled))D),%Y%m%d) Can anyone point me towards a solution?