Best Answers

Hi, this is a really basic question, but none of the other answers I've read have quite fit. What I want to do is simple - find the percentages of these two values:The answer would be NoBlank - 78.22% , BothBlank - 21.78%I'm aware the trick is to find a way to sum the Individual ID.total_count column in the Expression Evaluator, but "@sum@value(individual ID.total_count)' doesn't work, only returning the original values.  This so frustrating because I'm sure it's very simple.

Hi, I want to count values for individual fields in excel. There are 110 fields. I want total counts column by column for all values that are not missing, empty, or null.

I have a workspace that reads from a spreadsheet and dynamically makes attribute names based on a date column, with the values of the attributes being the services offered on that date, as shown.While the Feature Inspector sees these attributes, they are not exposed in the canvas and the writer is not aware of them, even when I make a dynamic writer and set Schema Sources as "Schema from first feature". Doesn't work with AttributeExposer either, as it does not see these dynamically generated attributes.The spreadsheet will have different dates every year. Is there a way to write these attributes dynamically into the writer?Thanks

Hi I'm new to FME and have been unsuccessful in figuring this out.My workspace originally had a choice user parameter where the user could choose a single string (eg. AA) which was then used to read GeoTIFFS that have that string in their filename.Now I want to have multiple choice, and I have changed the user parameter to be a Choice (Multiple). So the parameter ends up looking something like this: AB EB TTI'm trying to figure out how I can now have the workspace loop through and execute the transformers on each choice one at a time.TIA

Hi I would like to make boundries around my pointclouds.That way I can see if all my pointclouds cover an area.  I only know hullaccumulator, but that only makes a bounding box. See the picture below. I want the red boundry and not the blue one that hullaccumulator makes.I'm trying the pointcloudcoerser before the hullaccumulator, but I don't know if that works and it takes sooooo looong... Is there a better way? 

Hi everyone,I have an output from a PointCloudCombiner with 4 components (x, y, z, _distance). The _distance attribute comes from a NeighborFinder. What I want to do with the point cloud is to replace the z component of each point by its _distance value. I tried to use the PointCloudExpressionEvaluator after the PointCloudCombiner but _distance doesn't appear in the component list. I only have access to it as an attribute (not a component) and then get the same z value for each point of the point cloud... But when I check the PointCloudCombiner output in DataInspector I can see by clicking on each point that there is a _distance component that changes with each point. How can I have access to this component for further processing ? Thanks !

I have a shapefile containing points distributed every 5 meters in a regular mesh of 100 rows x 100 columns. I have to create a shapefile with points of this regular mesh located every 10 meters, or 20 meters, ... (always a number multiple of 5) to get a sparse mesh from the original. I there any FME Transformer that can help to do this task?Any suggestion or idea would be really appreciated. Thank you !  

HiI'm hoping someone can help me with a query.I have a SQL Server view that i am opening in FME; this contains both commercial and residential addresses The view has 2 reference columns, one contains a Council Tax reference, the other a Business Rates reference Some of the residential records do not have a Council Tax reference as they are not live properties; the reference column is NULL for these I have used a NullAttributeMapper to change the NULL value to New Build, but all records with a NULL value are being changed, including the Commercial records Is there a way of using the NullAttributeMapper to query 2 columns in the table so only NULL records that are residential. Or is there another transformer that would be more suitable?thanksSimon

Hello,I am new to FME. I want to load multiple shapefiles into Oracle spatial tables. I just have a problem with the extents. I would like to get them from shapefiles and use them as parameter in the Oracle writer but I don't know how to do it.I know the BoundsExtractor transformer but I don't know how to store xmin, xmax, ymin and ymax values as parameters, even more with multiple shapefiles.Thanks for your help!

Hello,I'm working on a French address table. A column contains a string with the abbreviated street type and street name, e.g. "AV DES CHAMPS-ELYSEES". I divided it and I built a list with its elements: AV, DES, CHAMPS-ELYSEESI now need to know if the first item in the list is a correct street type. For that, I have to compare it with about 200 values of a reference file, also stored in a list: AV, BD, CHE, IMP...I think I have to use PythonCaller but I don't know how to go about it. Can you help me?Regards,Nicolas

I have 2 Columns.First Column is the Date.The second Column has a value.I want to see for each Day in the first Column the sum of the last 7 Days.How can i do that in FME?

Hi, I am trying to essentially take one raster over another to produce one merged raster. With some simple logic if cell is present in raster B choose raster cell B otherwise A. When I do this the transformer just outputs and empty map. what am I doing wrong? Thank you

I have been building a server app that writes out an HTML that I was planning on streaming back to users. I was also planning on using an Emailer after this so was going to use a FeatureWriter with HTML output. However, I am finding that when I use a FeatureWriter for the HTML output, FME Server uses the data download service, not data streaming. But when I write the HTML out to a normal writer, the data streaming service works fine and the HTML page opens on it's own. Everything else is the same in the workspace and during publishing (with the exception of the included writers in stream, as it should be different).Has anyone else come across this? Is this a bug?I'm running 2020.0.2.1 Build 20238.

Hi, I am using the RegxAttributeSplitter. My delimiter has to be digits followed by a whitespace. I have used the positive lookahead Regex (?=\\d(\\s)) but instead of splitting the string and keeping the delimiter in the first list, the delimiter moves into the second list. I need my delimiter to remain within the first list, I thought the answer would be to use Regex negative lookahead (?!\\d(\\s)) but the negative lookahead stalls the transformer completely and produces no result. Any clues what Regex I should be using? I have also tried using Regex in the StringReplacer but no positive results here either. Below is sample of the string.. H02.CCU066 Sluice (Shared 2,Rooms)  H02.THD067 Treatment Area - 14,Spaces Yellow highlight is the delimiter moving to the second list

Hi everybody, I have written a very simple script that:Reads some ESRI-JSON placed in folder tree recursively (**/*.json)For every data which is in the same folder (= same type of data), gathers all entries in the same dataset and creates a new feature class with the name of the folder in an ESRI file geodatabase (having eliminated duplicates) Precisions:Every input json files in the same folder share the same schema. But in differents folders the schemas are not the same and there may be or not M values attached to the data. However, the field OBJECTID can always be found and that key is used to remove duplicates. Issue:I cannot find the way of setting the output port to retrieve the original schema which is the same of the JSON files the output dataset aggregates. When I check "Dynamic Schema Definition" I have no choice but to use fme_feature_type (the script fails otherwise) attribute but it represents the whole schema (since all files are ESRI-JSON); so there are lots of

Hi,I need some help with a specific fanout scenario. I already found some articles on the topic but unfortunately I cannot create the desired results. Here is what I want to to:  I have multiple input File GDBs, all with the same schema. In each GDB I want to manipulate one specific feature class and then write everything to new GDBs that have the same folder names and schemas as the inputs.  I know how to fetch multiple GDBs using a wildcard and I am also able to keep the input (feature class) schema using a dynamic writer but I don't know how to fan out the Folders. How do I fetch the input folder names (e.g. Folder1.gdb, Folder2.gdb) and use them for the fanout? Thank you for your help!

Hello, I have pictures in ecw format and txt description of the position from where the shooting was made with deviations according to omega phi kappa. How can you project an image onto a surface taking into account all the parameters?

I have a JSON file, structured like this:{  "W-Number": {    "EP1": [      {        "timestamp": 1407859200000,        "value": 1.35      },      {        "timestamp": 1407862800000,        "value": 1.44      }    ],    "EP2": [      {        "timestamp": 1407859200000,        "value": 1.58      },      {        "timestamp": 1407862800000,        "value": 1.63      }    ]  }}I want to turn it into a table, like thisW-Number | timestamp | valueEP1 | 1407859200000 | 1.35EP1 | 1407862800000 | 1.44EP2 | 1407859200000 | 1.58EP2 | 1407862800000 | 1.63What I managed so far: used JSONFlattener, then AttributeExposer to expose (see below*). Then I used a ListExploder; it works when I specify e.g. W-Number-EP1{}, which gives me a table for the timestamp and value of EP1, however I require a single Table for all EP's that might exist, without exploding the list for each manually. Would that be possible somehow? * 

Greetings,I am reading in Date/Time items in String format from an ESRI REST API. I have a field uploaded with values (below):1331249589000133124963400013312496460001331249638000  FME cannot identify/transform the values?? Any suggestions or pointers would be appreciated.Regards,Clive    

Hello, I would like to give the user the possibility to select a certain area when starting the script. The areas were previously recorded in a GDB and provided with a corresponding attribute. Furthermore a Published Parameter was configured according to the areas and their attributes.After starting the script, the user is asked which area is of interest to him and he can select it based on the predefined areas. So far this works wonderfully.My problem now is that my script only works as long as only one area is selected. If the user selects several areas, which should be possible, I do not get a correct selection. To test my result I have created a tester with the following configuration.My question now is, how can I successfully select multiple areas? Many thanks for the support.

I have about 3000 jpg and their coordinates in CSV format, I want to join the jpg and their respective coordinates saved on csv and create a ECW or Geotiff filehow can I do this

Is it possible to append to a json file saved as an Azure blob? AzureBlobStorageConnector overwrites.

Sorry, not sure how to word this correctly. For example, I have 2 published parameters. First parameter is StateName and second parameter is Cities. If I pick a certain state in the first parameter, could the second parameter (cities) only display cities in that state from the first parameter?

I am writing a text file with the csv writer. How do I force it to write the file with the extension "xyz" instead of "csv"?

FME Desktop 2020: How to permanently reorder the fields of attribute table of geodatabase feature class? In the screenshot below, I wanted to permanently move F3 to be to the right of F1. Which tool can be of help on this?