Transformers

Hi Guys,i have excel file ,i want to make comparisonasif sum 1 < base A < sum 2 if yes ,so as give me the outputi want to check for every cell in base A is the value between sum1 and sum 2 in the each row or not .as example check the first cell of base A (65452 ) is between sum 1 and sum 2 at first row or not then continue to check 65452,first cell of base A with the second row of sum 1 and sum 2 or not . i want to check for each cell in base A ,if this value between sum1 and sum 2 for each row .after finish checking 65452 so start with 65438 and so on so it will check for each cell with 10 rows i want to do the same also for Base B ,if the value between sum 1 and sum 2 and if yes gives me output and continue check for this cell till the end till i finish with all field cells in base A and base B Thanks in advance FME version 2018 

could i ask how to get in inspector only the lines that intersected with polygon ,i tried alot with clipperpolygon as input for clipper and lines input for clippee output from inside ,i got the intersected lines with polygon plus all lines inside the polygon .i want only to have the intersected lines with polygon and delete the rest of lines inside the polygon  how could also give intersected lines specific colour . Thanks alot 

I would like to ask ,I have two excel fileAs input First excel has only two attributes ,Column A is part of Column A in the second excel (exactly 10 Same iD of the second excel ),Column B is new data Second excel has Column A includes 90 Id,Column B,Column C,Column DI want to merge the new data on Column B to second excel and create new attribute Column EBut I found when I do merge ,I lost the data beside 10 ID that i want to merge ,it shows missing data. Could I ask ,how can I do that and keep the Data in excel 2 plus Data in Column B from the first Excel .

I need to transpose some of the attributes (with prefix "INTER"), but keep the other ones not transposed.Original data looks like this:The result should look like this:Except not transposed attributes should have values. Obviously AtributeExploder doesn't do the job in this case. How can it be done?

@garydlesterHi !I'm trying to do an elevation profile of some network lines to be exported in AutoCAD. But I'm not being able to adapt the labels and grid so as to be able to view the profile of each section.Could you please help me.Thank you very much.

I am trying to modify an existing workbench which reads features from an Oracle database using an SQLCreator and writes them to a feature class in a geodatabase. Currently there is a single query in the SQLCreator. I'm trying to add something to the output which requires a temporary table so I now need there to be three queries running in this SQLCreator:Create temp_table;Query to extract features from Oracle DB (and temp_table);Drop temp_table; Is it possible to run a series of queries in SQLCreator? If not is there some other way? The series of queries work fine when run directly against the database but I cannot get it to work in FME. My fallback is to create views in Oracle rather than using a temporary table but I'd rather not do that if I can avoid it. Thanks,Michael

Trying to use the long-awaited 12D Reader but the resulting lists are overwhelming. Basically, there are pairs of attribute names and values scattered across lists of various depth and ideally regular attributes with values could be constructed. The attribution in 12D and the resulting lists are bound to different levels of a 12D model. Some attributes belong to the whole model, some to geometries and some to individual vertices. Hence the extensive lists.Vertex attribution: The best I managed is a sequence of List Exploders to get to the last position of a list and then build the attributes using ListKeyValuePairExtractor - This custom transformer seems to struggle with the long nested lists; works fine with pairs on one level. It ends up with duplicated geometries for each list pair but it could be flattened by Feature merger and Matcher.Using this approach I need to inspect the lists manually and identify on what level of a list particular pairs are.Any idea how can this be achieved

 Hello Guys ,i want to split ths two lines that intersected in point, i have coordinates for each x maximum and x min. and y max. and y min , i know,one of them is xmax and the another should be in this case minimum one also is ymax and another should be ymini used topology builder static to make group network id and it did correctly but this two lines i do not want to be in the same group so i used clipper points as input and lines as clippe but i found it did nothing .bcs i used after that zopology builder static and it consider both of them in the same group and i want to give each one new network id so is it possible , to make topology builder static with condition that create network id for all lines except the when it occurs value of x max equal value of x min ,value of y max equal y min .do we have conditional to write it for topology builder . or could i use clipper to split two lines when x min value and x max are equal y min is equal with x min .

I have a coarse raster where the pixel value indicates the number of points that should be generated within the confines of the pixel.  I have a fine raster (1 to 2 orders of magnitude higher resolution than coarse raster) where the pixel value indicates whether a point can be placed there. For simplicity purposes this can be a binary mask.  I would like to generate points according to these two rasters with the additional criteria of a minimum separation between points.  Thoughts on how to do this in an efficient manner? I'm hoping to avoid the brute force approach of generating a random point, checking the constraints and repeating until the desired number of points is reached.

I have a Maria DB and a JIRA platform, I would like to use the DB to create new issues there through the JIRA API, how can I integrate all of them? I have already made the regular CRUD operations to the JIRA platform through the API using the HTTP Caller, but, how can I properly use the SQL Creator to use that data?

 I have Oracle no spatial as a reader and when i am trying to read the coordinate ,i found the output is null and i have read many articles and i tried many hours but without any success . could someone help me ,how can i fix the problem for Geometry for Oracle non spatial  in inspector the output of oracle ,it looks like points and each point has his coordinate (x,y)  Thanks in advance

We have a FME workbench where CSV input is being translated to Shapefiles. This workbench has manually created mapping of attributes e.g. Nominal_Diameter on input and NOM_DIAM on output.Due to some issues with the old workbench I'm trying to re-create the process. And for that I need the attribute name mapping. But I don't want to do it manually as it will take a considerate amount of time.Is there a way how to extract this information from the workbench? E.g. as a text:feature, original attribute name, new attribute nameThanks, Jan 

I want to create Justify aligned Paragraphs in a docx file. I created a custom Heading with Justify alignment in a seed file and input the text via a MSWordStyler transformer with Content Type: Heading and Heading Level: Heading X. but I can't get the text to display correctly. It always spreads the last line. I even tried to use CR and LF in the Text Editor.The text outputs like this:I would like the text to diplay like this:Transformer setings:  Any ideas on how I should configure this to display correctly?

I would like to use JSONTemplater to build nested text structers making use of the ROOT and SUB TEMPLATES but this are not valid JSON ... its  a Groovy syntax ... Beacause is not a valid JSON format the JSONTemplater gets offended and stops the translation. i cant find a way to skip the JSON validationsI tried disabling validation ,,, but nothing ... any alternatives ?   2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): The following error occurred near line 1, column 11 of the query:2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): An error occurred while parsing the ROOT template2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): A fatal error has occurred. Check the logfile above for details  Thanks

I have a point vector shape file that consists of the vertices of a number of lines. The data looks kind of like this: (extremely simplified values, but the same format)Feature NumberVertex NumberxyzLayer00101315Main Cable01121420Main Cable 10345Secondary Cable11478Secondary Cable125710Secondary Cable What I want is to create lines that consist of x, y and z values using the feature number as the grouping attribute, ie. All points that have a matching feature number would create a single line, with the vertices starting from lowest to highest. I have tried using CAD, FME and Excel but have had no success.  Thanks in advance!

Difficult to word this one.  I need to generate a table where attributes are generated dynamically e.g.NameFeb-20Mar-20Apr-20      Where the attributes reflect every month from "now" for a set period e.g. a year. I have created a workbench which generates the month-year as attribute values dynamically and then creating Attribute names from these values. However, I can't seem to find a way of exposing these attributes dynamically so that I can then assign values to them. (Currently I have to export them and then reimport them within the attribute exposer). Is there anyway of doing this in a more streamlined fashion?

 i have many lines with diferent id and also Lines with many segments connected together between two area and i have 5 area with different id and different lines intersected with the same area and another lines intersected with another area and so on .some and i have the coordinate of points x,y that refer to the location of point intersected lines with in area ,i want to get the name of area that intersected with diff. lines ,and which lines intersected with this area and and i want to get also when line intersected not only with one ,may be 2 area so i want to know the id of this line and the name of two area that it intersected with . FME 2018 Does spatial relator the transformer that i want or which transformers should i use,i am new in map and iam new in work on map and i am still reading and learning about transformers

I have a shapefile with an attribute ID that contains 23 objects (polygons).I want to use this shapefile to clip the las files and combine them based on the objects.So I want 23 point clouds. I have an idea on how it works, but want to be sure as this is going to run for a long time. My bench looks like this:In clipper I would turn on group by "ID" and merge the attribute just to name the Las file by the value in ID. In pointcloudcombiner I would turn on group by "ID" will this give me the result I want?                 

Hi,I'm new to the FME family and have this question. I have a Civil 3D dwg that we want to transfer to a geodatabase. Transforing the geometry is no problem, but the dwg has extended entity data that I want as attribute fields in the geodatabase.But, at this time, I can't even find my extended data when inserting the dwg as a reader. I searched this community but so far no luck. I tried the 'AttributeExposer' or ListExploder' transformers, but still didn't get result.Can someone tell me how to set the parameters so I can read the extended data and will be able to transfer them as attributes in a geodatabase?Thanks,Davy

Hello, I'm using attributevalidator to make multiple check on attributes. There is one check I don't know how to implement. I would like to hightlight the attributes finishing with newline. I used this regex : [^(\\n)]$ . It is working when I use external tools (for example (https://regexr.com/ ), but not in FME. I didn't find any other regex to do that (I'm a beginner in regex).In case, there is one other solution : using tester/attributecreator, but if possible, I would like to gather all the tests in the same transformer to make the workflow as simple as possible (the workflow contains a lot of attribute / spatial tests) Thank you  

When copy/pasting SQL code into the SQLCreator SQL statement editor (2018.1) specific characters are replaced by others, e.g. '}' becomes '%7D'. This doesn't happen using the 2017.0 version.How can I make it work in the 2018.1 version?

Hi All, I'm trying to select parallel lines from a shapefile using FuzzyParallelLineFinder. The output gives line_ID of the fuzzy parallel line for each feature with a given STDV value. What I need is how to select the features that are expected to be parallel from this output.Any ideas?

Hi there,I want to create two columns: One column generates the dates between two given dates and second column contains the half an hourly time stamp of each date. For example:Column AColumn B1/1/202000:001/1/202000:301/1/202001:001/1/202001:301/1/202002:00............................................1/1/202023:302/1/202000:00 So that means each date of column A would have 48 values (half an hour slot) of column B. Could you some one tell me how to do that in FME?

Just wanted to know on JSONFragmenter between 2017 (17259) Vs 2019.2 (19817): What i have noticed is, JSON fragmenter never returned anything when the fragmented value was 'null' in 2017, while i have just noticed that for the same JSON text input, JSON fragmenter on 2019.2 is sending the attribute with 'null' value that we wanted to fragment through 'Rejected Port', is this intended on 2019.2? Any answer would be appreciative as we have lots of workbenches that we need to go through and fix it if that's the case?