Transformers

Hi, I have imported an Excel spreadsheet into FME, one of the columns contains data similar to the below, I am looking to filter the records between the PTO On and PTO Off values, anything else I wish to remove.Is there a way to do this using FME transformers? Many thanks for any help in advance. Ignition OnJourney StartIdle StartGPS PeriodicGPS PeriodicGPS PeriodicDigital Input 0 HighPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicDigital input 0 LowPTO OffGPS PeriodicGPS PeriodicIdle EndGPS PeriodicGPS PeriodicDigital Input 0 HighGPS PeriodicPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicIdle StartGPS PeriodicDigital input 0 LowPTO Off Thanks,Charlie

I use the ZipExtractor and ZipArchiver custom transformers by @takashi from the Hub on FME Server 2016 for multiple processes. Now we are migrating to FME Server 2019 and these are not sustainable because of Python incompatibility. I found the FileCopyWriter can work as an alternative for the ZipArchiver. Does an alternative for the ZipExtractor exist?The alternative is I try to upgrade the ZipExtractor to Python to 3.x but as my Python-fu is not amazing... I know Readers can read directly from Zip but my current proces unzips the entire Zipfile and then processes the different unzipped files.

Intersecting some points with polygon features, there are multiple points per polygon. The trouble I'm having is I'd like to have a delimiter separated summary of an attribute from the joined points. As an example, three points might intersect one polygon (they have ID values 1,2 and 3). The desired output would be polygon geometry with a field called Summary ID and a value of "1;2;3" for that polygon. Does anyone know of a transformer that might handle this attribute merge?  

Hi there,I'd like to know how I can detect scenarios where polyline features cross each other without the presence of any vertices. See my awful paint work as example:So in this scenario, both the red and blue line has no vertices where they cross. These kinds of situations, as well as one where just one or the other has no vertex, is what I'm trying to identify. Meaning, in all cases in my data, both edges need to each have a vertex wherever lines cross. Thank you in advance!

I want to categorize all properties across BC based on the federal electoral districts. I have the Esri Geodatabase file format for the federal electoral districts and have all the properties with their latitude and longitude information stored in a table. what will be the best approach to resolve this ?

Hi everyone,For each record in the CSV file, I want to find the closest point to it from a SpatiaLite database using SQLExecutor. What's the most efficient query that I can use to tackle this task because my SpatialLite DB contains over 35 mil points? Thanks in advance! 

Hi, I am trying to pull some content from XML and making a mess of it.I use the XMLFragmenter extract from this:<?xml version="1.0" encoding="UTF-8"?><wfs:FeatureCollection xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wfs="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml" xmlns:workspace_wfs="workspace_wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" numberOfFeatures="5" timeStamp="2019-10-11T13:52:44.446Z" xsi:schemaLocation="http://www.opengis.net/wfs 

I need to join fields from one table to the another. Because of the nature of the join, I only want one match per record. If there is more than one match, that is redundant data. It looks as though the FJ is adding records when there is more than one match.Can I tell it to take the first match, so that my output has no more records than the input - "Left" table? Thank you, Randy McGregor

Using FME2019.1 I get some unexpected behaviour of SpatialRelator3.Instead of 'merging' values from SpatialRelator & SpatialRelator_2, FME seems to copy attribute values from one attribute to another. (see screenshot).'grafnummer' & 'bloknummer' should have different attribute values but FME seems to 'copy' values for both attributes. This behaviour does not occur when running the workspace in 2018. 

I had a BulkAttributeRenamer with the following parameters:  To remove all attributes that have names with invalid characters. But this setting holds the entire process without error. No features going in. If there is a blocking transformer before the BulkAttributeRenamer you will see log Messages going out of the last transformer before the blocking transformer. But nothing after that. First i thought that the blocking transformer would be the bug. But changing the settings of the BulkAttributeRenamer to Text to Find: [ \\\\] fixes the process.The bug is in:2019 beta2019.0.0.1 The bug is not in:2018.1.1.2     

How can I write the selected attributes to CSV from AttributePivoter?I don't know the names in advance it's a dynamic list of attributes.

I'm migrating a project from FME Server 2018 to FME Server 2019.0.0.1 (build 19246) and am seeing this error when running a workspace on server 2019 that used to work on server 2018.50InlineQuerier (InlineQueryFactory): An error occurred while creating the table 'features'51InlineQuerier (InlineQueryFactory): Database was unable to define table 'features'.52A fatal error has occurred. Check the logfile above for details When I run the workspace locally in FME Desktop 2019.0.0.1, I don't get the error. Here's a mini workspace that has the same issue: What can I do to get my workspace running on server 2019? 

Hi all, I am trying to calculate the surface area of different LULC classes. I have to do this for very many different polygon areas, using the Rastertopolygoncoercer takes too much time, so I do this by counting the pixels of specific values, and then calculating the surface area based on the pixel size of my raster. Ordinarily I would do this with the ArcGIS Zonal Statistics function for rasters with the "count" functionality and be done with it. This does not seem to exist in FME, the RasterStatisticsCalculator misses this feature (and only that feature, strangely). So what I do instead is per class, replacing the cell values with 1 (and all others 0), and then calculating the "SUM" with FME's RasterStatisticsCalculator. It gives me the result I want (in a cumbersome roundabout way) but then, I want to save the attribute table separately from the raster. Because when I do a rasterstatistics of

Hello everybody,I just have one tricky issue - how can FME detect attribute value, which is composed strictly by white spaces, e.g. ? Its not empty value in DB view, but it is hardly detected. Any idea please?It doesnt matter on count of white spaces.Thank You so much!Lubo

As question title mention it, I would like to split an Access table's fields to be able to connect transformers on several fields in order to achieve date formating.I've been able to connect one field (DConseil) but I wonder how to connect specific transformers on the others date fields and let them work simultaneously, if it's possible.I've tried several times to redirect features through spliting, filtering, testing, and so on but I'm certainly thinking the wrong way.To keep it simple : how can I achieve a "routing" before adding transformers on each ports.Sorry for any duplicate but I didn't find any valuable answer to my problem for now.Thanks in advance for any help.Pierre.

Hi everyone, I have a geometry question.As you can you in the following image, I have three different circles that overlap. How do I extract the red lines?

Hi All,Thanks to all the experts for providing solution to my transposed doubt sometime back.Here is an another challenge that i faced with now. I now have multiple columns instead of two.where [A-R] are the required column names and the data from column 2 to last column should be the rows. Now i want two solutions:1) Transpose only the given data in pic (must need)2) The set of required columns (A-R) will repeat for the next file(when reading batch files) and needs to be given a common id and the entire data transposed. (optional) Kindly help. Thanks

Hi All,It seemed a bit easy but i am stuck with it now. Can someone please help?My input is somewhat like this: and my desired output is like this:The 6 values (Acquisition date, Analysis Date, System, Method, Sample ID and Data filename) are repeating three times in first column and have different values. I have attached the excel file for your reference.

Need a outputOutput from JoinerMy linked xcel file

Hi, I have observed that the pixel values of sentinelhub data and S3 bucket data are different. I have tested by downloading same date tiles from sentinel hub and FME S3 Bucket. Do anyone know why the values are different? or which data to use is preferable like is the error is in sentinel hub or S3 bucket or FME extraction.

Hello,I'm trying to figure out a way how to do a data profile, similiar to skim in R.Something like this:But idealy without having to use the Python, or R caller...The statistics calculator does count, min, max, etc, that helps. But I need unique, missing and nulls as well.Is there a simple way how to do this in FME? 

Hi, We have a workspace that runs fine on our FME Server testing environment yet crashes on our user acceptance environment. It crashes on version incompatibility, like described in the article at https://knowledge.safe.com/articles/363/workspace-fails-on-fme-server-fme-version-incompat.html. Granted, we use FME Server build 17650/win64/2017.1.1.0 and FME Desktop build 17652/win64/2017.1.1.1. that would be a cause for not running a workspace due to compatibility issues.However, this baffles me: FME Server version is the same, workspace is the same, what else could cause this behaviour? I narrowed it down to the workspace below, which is basically a SpatialRelator comparing two box-like area's. Our testing environment runs it just fine, and concludes in the log:2019-10-09 12:23:30|   0.3|  0.0|INFOR

I have downloaded a date range images of sentinel 2, performed clipping (polygon) and calculated NDVI. Then I have converted raster to point and extracted each pixel values parallely extracted coordinates from coordinate extracter. So in attribute table I have date for each pixel, NDVI value of each pixel , latitude and longitude of each pixel. But I need attribute table structure as Latitude, Longitude and each day Ndvi values. So each date of image generated should create a column and writes NDVI values for same lat longs.

Hello,I want to find a regex with python caller.  The text_line is like Híd neve: Líra utca -  gyalogos híd. And I want to get only: Líra utca -  gyalogos hídI was able to do it with StringSearcher, where the expression for the regex was like : (?<=Híd neve: )\w.* Now I am tring it within python, but it doesn't give back value (it should be like: Líra utca - Ördög-árok feletti gyalogos híd)Could you help me, where is the mistake?class FeatureProcessor(object):    def __init__(self):        self.comp_re = re.compile("(?<=Híd neve: )\w.*")        #pass    def input(self,feature):        text_line = feature.getAttribute('text_line_data')        matches = self.comp_re.findall(text_line)        if matches:            feature.setAttribute('PyTrackExtents', matches[0])        self.pyoutput(feature)

This is very country-specific as Interlis is only used in Switzerland, and FME relies on a plugin (Eisenhut) to read/write Interlis-Data.I have done a lot in Interlis1 (ASCII), which always worked like a charm. No I am on my first Interlis2 (XML) project, which also worked fine just to this problem.FeatureTypes and their attributes in Interlis are set by an Interlis Model (*.ili). In this model there is also set which "attribute" is used to store the geometry per featuretype. So, e.g. a line in interlis stores its geometry in the attribute "Lage" (which stands for "position" translated in English)For the Labels, I now have two Classes "InfrastrukturHaltung_Text" and "InfrastrukturKnoten_Text". For this Label-Classes the defined attribute for geometry is "Textpos" (stands for "textposition").  My problem now is, that after importing these two featur