I have a workbench that goes as follows:
- Read in attributes from a CSV. The attributes are locations, and
- Join those records with a buffer and spatial relator to find potential conflicts near the input location
- Write out the records to a PPT file
The input table would look something like this
Location 1 | Table Text 1 | Table Text 2
Location 2 | Table Text 1 | Table Text 2
Location 3 | Table Text 1 | Table Text 2
And ideally, the final PPT file would look like this:
Title Slide: Location 1
Table Slide: Table Text 1
Table Slide: Table Text 2
Title Slide: Location 2
Table Slide: Table Text 1
Table Slide: Table Text 2
Title Slide: Location 3
Table Slide: Table Text 1
Table Slide: Table Text 2
and so on
It's in step 3 that I run into issues. I can't find a way to dynamically filter attributes so that I can write to separate slides like I see in the tutorial. The attribute names aren't fixed, so the Attribute Filter doesn't work, at least not that I can see so far. https://community.safe.com/s/article/getting-started-with-the-powerpoint-writer-tables
I think I can get the sorting done, but feeding the separate and unique attributes so that the PPT won't combine everything under one slide has been challenging. Is there a better way to do this? It's possible to separate files with the fanout transformer. But managing 5 or 10 or 20 individual PPTs for each record in the table is a pain.
