Transformers

i have output of transformer l , it looks like the above table. in the inspectori want to split this table automatically depends on the amount of cells in ID column .as here the table has only 4 rows but sometimes i got another output with different rows ,but any table has idso i want to divide the output of transformer to many seperated output and each output has his own id with his row bcs i want to do some actions later and connected seperately with some transformer .i need the output looks like the picture as down , but i want to create way automatically whatever the amount of ID ,get me the result output seperately .exactly , i have lines with different id and this is the output as shown above. Thanks for help 

 as you see in photo no amount of numbers get out of polygon so i will not see anything if i connect the polygon with inspector so what should i do ,both of them get from the same file,is that normal or there is transformer should i add before work on it .thanksbut if click inspect on polygon it hows me in display control,ellipses and lines and multi text and points and shapes and text .but if i create inspector and connect with polygon it shows nothing,it does not give me the fme data inspector to see how it looks like ,what is important for me i want to find intersecton between lines and polygon but lines show me amount of numbers on output but polygon show nothing so the ouput is wrong .i hope,i find answer.thanks

@takashiGreetings FME sensei, good to see you're still around! I had a question about a Python script I'm using as a Private Parameter linked to two published parameters to generate log file folders that include the local user and date in the folder name, then generates time/date stamped log files within those folders.Here's the script:# Scripted (Python) Parameter Example # Create log file path with time stamp. import fme, time, os d = FME_MacroValues['Log_File_Dir'] # directory path w = FME_MacroValues['User_Name'] # workspace name t = time.strftime('%Y%m%d%H%M%S') # time stamp f = FME_MacroValues['Folder_Name_Date'] # date in folder name # If the workspace name ends with ".fmw", remove it. if w.endswith('.fmw'): w = w[:-4]  # Create a new folder which has the name of the workspace. dir = os.path.join(d, w, f)

Is there any transformers to aid in  MultiPolygons to simple Polygons.  I'm going from ESRI Geodatabase to SDF.  Chris

The equivalent tool to “pivot table” of ArcGIS in FME,    I couldn’t figure out which tool is equivalent to “pivot table” of ArcGIS in FME. I have a layer and I want to rearrange the attribute table in a specific way  The following picture shows my need    when i use the pivot table tool the table is look like this        Thanks in advance  Best

i have numbers in String format but need to translate to numericlike belowOriginal StringNeed to be convert One 1 Two 2 Three 3 Four 4 Five 5 Six 6 Seven 7 Eight 8 Nine 9 Ten 10One Hundred and Fifty Nine 159Five Hundred and Nineteen 519Nine Hundred and Fifty One 951 Two Thousand Four Hundred and Eighty Six 2486 Two Thousand Six Hundred and Eighty Four 2684 Six Thousand Eight Hundred and Forty Two 6842 Eight Thousand Six Hundred and Twenty Four 8624 Eight Thousand Four Hundred and Sixty Two 8462 Thirteen Thousand Five Hundred and Seventy Nine 13579 Thirty One Thousand Five Hundred and Ninety Seven 31597 Fifty Three Thousand One Hundred and Seventy Nine 53179 Seventy Five Thousand Three Hundred and Nineteen 75319 Ninety Seven Thousand Five Hundred and Thirty One 97531 Note: I'm getting value upto 7 digits.

I have the following that worksSDE DATA => Test Filter (Name = Point) > XMLFramenter > Rest works as expected 1 feature coming throughI want to remove the Test Filter and and put an SQL Where clause at the SDE Data level ( Name = Point ) the SQL is valid and 1 feature comes through however the XMLFramenter fails.Looking at the data in both cases for the field that contains the XML data is identical yet it fails in one case and not the other, any ideas?

Folks,I need to scour some file shares with a python script to identify any data files. I would like to exclude 'non data' files and it occurs to me that one way of doing this would be to compare file extensions with a list of format-specific file extensions that are used by FME Readers...The Knowledge Base does list file formats (https://www.safe.com/fme/formats-matrix/ ) but doesn't specify the associated file extensions.Does anyone know if there is a matrix that lists the file extensions associated with each FME Reader?Many Thanks, Graham

HiI am using the R caller for creating a scatter plot with 2 variables and I would like using 2 different colors for the 2 variables. I am using the following function:plot(wells, col = c("red", "blue"))Yet it comes out black!Any ideas Best regards, Felipe Verdú

Hi, I have achieved the below XML using the following xquery in an XMLUpdater: XML: <base>  <level id="Level-1"/>  <group id="A" category="line">  <section id="A1">  <definition>  <edges>  <edge id="110992"/>  </edges>  </definition>  </section>  <section id="A2"/>  <section id="A3"/>  <section id="A4"/>  </group> </base><base>  <level id="Level-1"/>  <group id="B" category="line">  <section id="B1">  <definition>  <edges>  <edge id="128677"/>  </edges>  </definition>

Hello all, I have a series of flow paths along a network, each with a unique ID. I want to essentially produce an elevation profile graph along each path by sorting the data and writing into an excel template.I have split the single paths at each node, and linked the elevation of that node to each _from_node and _to_node. However, i'm struggling to figure out how to sort the data in the order of the path. Each path doesn't follow the pattern of Node 1 - Node 2 - Node 3, etc. Some will jump around, e.g. Node 1 - Node 2 - Node 13 - Node 7, and so on.The information is contained within the _from_node and _to_node attributes, but i cant figure out a way to sort this data, apart from possibly using an indefinite number of joins on the _from_node and _to_node attributes.Any ideas would be greatly appreciated!Thanks!Jack

Hi all,  Can the AttributeManager perform operations like the StringSearcher?  I would like to extract certain strings from an attribute called RAW_DATA, I'm looking for the value in "value="xxx" e.g. <span class="store-card__value">Mon-Fri 09:00 AM  - 09:00 PM </span> <span class="store-card__value">Sat 09:00 AM  - 06:00 PM </span> <span class="store-card__value">Sun 10:00 AM  - 05:00 PM </span> </p> </div> <div> </div> <div class="store-card__section"> <a class="store-card__action" href="/teststore.com">Store Details</a> <button class="btn btn-tool store-card__action storeSelectButton selectCategoryStore " id="selectCategoryStore_699" name="699" value="699">Store</button> </div> </section> </li>

Pretty sure someone has this resolved. But I just could not find a clean solution to a seemingly basic request...Before we do an overlay operation of Layer A and Layer B, we need to first test if their CSs are the same. If they are not, Layer A needs to be reprojected to the CS of Layer B.CoordinateSystemExtractor is used to extract CS as "Attribute" from the two respective layers. But that was how far we could go: A - How can we compare the CS when the two CS Attributes are in two different datasets? B - How can we set the "Destination CS" parameter in the Reprojector transformer of Layer A to point to the CS Attribute from Layer B?Thanks!

I am using FME workbench plugins in ArcGIS Pro to translate my IFC to Shapefile, where after I assign a coordination system for London it shows many projection error. So, how to solve it? Is there any solution for it? 

hello,i am confused a little bit ,how can i use FeatureMerger correctly.I have two excel on my workspace ,Excel A : has three rows but one of them is duplicate from Excel B ,and two rows not .Excel B has 50 rowsi want to merge Excel A with Excel Band if we have any duplicate row (i mean the one of Excel A) ,remove the duplicates and keep the rest of rows .so As a result,i need to have Excel that contains 52 rows .i read alot the Documentation but iam still confused in adjust properties of Featuremerger ,i will be thankful if someone help me .thanks 

FME 2018.1.1.2 Is this expected behaviour? I've set 2 Lists to be removed from the WorkBench features by AttributeManager. Opening the Partial Results of the Output Port in Data Inspector, they are indeed removed.Yet, in the very next Transformer (happens to be TopologyBuilder) the 2 Lists reappear again on the Features when the Output Port is inspected in Data Inspector, complete with the original list values? Not only that, but trying to remove them with a subsequent AttributeManager, AttributeKeeper etc. does not work, because these Transformers don't think that either of the Lists exist anymore in the Schema and hence won't appear in the selection of Attributes/Lists available to modify! These Lists continue down the Workflow in the Partial Results but remain invisible in the Schema. Further, if I replace the AttributeManager with an AttributeKeeper, the Lists stay removed (and I guess is a workaround?). I'm guess

Hi,I have a bunch of JPEGs taken with a drone that contain spatial information within the embedded exif.I am trying to enable each JPEG with the end goal of georeferencing them so that they can be made into a mosaic. I have tried combining transformers such as the PhotoCoordinateExtracter, CoordinateSystemSetter, RasterGeoreferencer, and the RasterMosaicker to no success.Also tried FeatureWriter to GeoTIFF then FeatureReader to no avail. When I drag them (JPEG or GEOTIFF) to ArcGIS for example, they all occupy the same space.What is the best workflow for this?Cheers

Hello,I would like to tranpose my data into a new table format. I found a similar post here https://knowledge.safe.com/questions/88862/transposing-data-into-a-new-table.htmlBut I am not able to get the result I want. The main difference is that I have much more columns and rows than in the post I mentioned above.The dataset I have:DBKAlCl...10.151.1...20.201.2...30.251.3...............With the 3 dots I want to indicate that it is a large amount of data. So much more columns and much more rows as well.I would like to get the following format:DBKParameterValue1Al0.151Cl1.11......2Al0.202Cl1.22......3Al0.253Cl1.33............... So the three dots indicate that there are much more parameters for each DBK and there are also more DBK's.In the post I mentioned above they use an AttributeExposer at the end. But I d

Hello!I am wondering how can I use FME to analyse graphe?I have points that represent a surface and I would like to analyse these surfaces with local maximum and/or minimum. But the surfaces are not always simple, some of them is almost like a line, but some of them are like a roof - as represented on the picture.Is there any way to fit a line to these points, and analyse the parameters of these lines, like determinant. Or is there any algorithm that could compare these generated lines with sample functions?Do you have any advice?

This one is already solved. Writing is for documentation only as I could not find the solution here.I had to debug a workbench from a coworker which was failing with the following error:WARN  |ChartGenerator: Non-numeric input provided.  Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericFATAL |f_24(PythonFactory): PythonFactory failed to close properlyERROR |f_24(PythonFactory): A fatal error has occurred. Check the logfile above for detailsDue to the log pointing to non numeric input in the ChartGenerator it took me some time to find out that the error was caused by something different: One of the attribute names used in the ChartGenerator in the "Y attribute" contained a space.I tested this in desktop 2017.1.1.0 / 2017.1.1.1 / 2018 beta (build 18220).This is a known issue and filed under C133238.

Hi there, I am applying a filter on record using tester transformer. My test clauses contains multiple And/OR conditions. I have attached screenshot of the test clauses. The problem is tester does not filter the record the way I wrote the condition. For example, I dont want to include the record in which CAUSE attribute has value 2A or 2B. However, in the tester passed category contains the record that has CAUSE value of 2A or 2B. Similarly, I do want to include the record in which the description attribute contains the value "BLOWN LV FUSE". However, passed category does contain those records. Could anyone guide me where am I making the mistake?

I would like to use an attribute value for a new attribute name using the Attribute Creator transformer, but this just not working. The new attribute is not created even if we can parameter the Attribute Creator to do so:I am using FME 2018.1.0.1 64bitsI have found this old question with the same issue. According to the accepted answer, the issue was suppose to be fixed in FME 2017. So is the problem fixed or not?

I am working on a project where I have to create maps. I have a file gdb and a personal database .mdb. Everytime I have to create a map I have to join them. Is there any way that the .mdb file can be just linked to the .gdb file so I dont have to do the join operation? Is there a way where the attributes that are stored in the .mdb file are just incorporated in the file geodatabase without doing the join operation?I further intend to convert the file geodatabase to a shape file, such that each feature layer has its own attribute table.Any help willl be much appreciated. Thanks in advance!@takashi @david_r @redgeographics

Hi All, I have date values in five columns, however, not all rows have date values in all five columns. For example, row 1 has values for columns 1, 2 and 3; row 2 has values for columns 1, 2, 3 and 4; row 3 has values for columns 1, 2, 3, 4 and 5; row 4 has value for column 1 only; and row 5 has values for columns 1 and 2. The rest of the columns not mentioned in each row have <missing> values.I want to create a new column called DATE and populate it with the last date before a column value of <missing>. For example, row 1 will have the date value from column 3; row 2 from column 4; row 3 from column 5; row 4 from column 1; and row 5 from column 2. Thanks for your help in advance.RowDate1Date2 Date3 Date4Date5 DATE114/01/201815/10/201916/01/2020<missing><missing> 16/01/2020219/01/201513/01/201711/01/201801/01/2020<missing> 01/01/2020 318/01/201415/10/201511/01/201601/01/201910/01

Hellosorry for my EnglishWe want to create a modifiable client web so that the departments are able to create, modify or read on a single map which will be fed by the drawing departmentWe create layers and attributes in qgis to be able to create and modify it's addition in the client web.The dwg is only for reference in the web client editable web client (lizmap) Other departmentsqgis connects lizmap with linux server ..postgisautocad map (drawing dwg) Drawing department I would like to take a dwg which is still in production by the drawing department ... which will be visible in the client web ...My problem is that the dwg is not compatible with qgisIs it possible to send dwg in postgis .. so that I can retrieve it in qgis .... for which can be displayed in the web clientUnless you have another alternative I don't know if FME products will be a solut