I have a set of polyline features and a set of point features in a ShapeFile. Each set of features has a RID field. The RID for a polyline record corresponds to an RID field for the points. As expected, one line has many points that comprise it. There are 10-20 lines in the input dataset and ~1500 points. I just want to show each unique RID value as a different color in my output KML file. The workbench goes something like this:
1) Read the Lines and the Points
2) Read a SQLite DB containing a table listing a RID, and a Color (both RGB 100,100,100 and KMLColor FF00987F format (http://www.zonums.com/gmaps/kml_color/)
3) FEature Merger moves the attributes from the SQL Lite DB to the Shapefiles, the reprojector, 3dforcer, KMLPropertySetter then the KMLStyler where the colors for all symbology is set using the fields containing the colors merged from the SQL lite databases.
4) The resulting data is written out to the KMZ.
The issue is that neither the RGB or the KML Color values are applied to the outgoing features. One or two of the lines show up in RED, the remainder show up as plain black lines. I want features with RID=1 to be red, RID=2 to be yellow, etc.
I'm using FME 2019.0.2.0 - 20190605 Build 19260 MacOX, 64=bit.
Thanks,
@pcgveenstra