Alteryx Process

Sorry. Should have said. The rrrrr above should read BLUE

Hi @fordy,

This is definitely possible to do in FME. As @davidrasner5 mentions, you will likely have to work with some lists, the AttributeSplitter and the ListExploder being helpful transformers in this process.

Here are some of the steps to get the workflow you're looking for:

1. I read in the line as a textfile in the TextFile reader

2. Used an HTMLExtractor to grab the coordinates and the colour values. For me, setting up this transformer correctly was probably the hardest part (thanks @debbiatsafe!)

    

   

3. Since we grab those as List Attributes, we want to explode the list into attributes in our table by using the AttributeExploder on the coordinates. I use a second AttributeExploder for the colour

4. Next, I use an AttributeSplitter on the coordinates list with the delimiter set to ', ' or 'comma+space' which creates a new list of coordinate pairs. I have named it _coords

5. Explode this list (_coords) into attributes.

6. What's left now is to concatenate it in the format you want. I did this using a StringReplacer and a StringConcatenator. My output looks like this:

    

   

My final workspace then looks like this:

 

Alternatively though, you had mentioned wanting to bring these coordinates as polygons into Tableau. We actually have a tableau writer that you could write directly into instead. To do that, I believe you could create well known text (WKT) from your coordinates to write into Tableau as one possibility. This Q&A might be helpful for creating WKT. There's also some tableau tutorials here.