Write Subgroup Lists of SDE Feature Class to Google Sheets

It would be better showing some sample input data, and the desired sample output.

In a physical data sense, ListBuilder “pivots” data such that Eg.

Input

Floor, Room

1, A

1, B

1, C

2, D

2, E

...using ListBuilder, with Group By Parameter set to “Floor”, becomes:

Floor, Room{0}. Room{1}, Room{2}

1, A, B, C

2, D, E

Hmm, maybe a list isn’t what I need. I want to extract each row of rooms that match to a specific floor ID, and write all those rows to a Google sheet. For example, a sheet with all the rooms and their attributes for the 1st floor of Lincoln high school main building, another sheet with all the rooms on the 2nd floor, etc. Basically just turning one master SQL table of 15000 room entries into hundreds of tables/sheets for each floor, in each building at each site. I’m just not sure what combinations of transformers I need to get there

Basically:

• Use an AttributeCreator for each read row to create a “Sheet Name” Attribute, which could say, a concatenation of Building Name; Floor
• Use this Attribute value in the Writer/FeatureWriter   for the Sheet/Feature Type Name Parameter
   

This is a form of “Fan Out” where the one Writer/FeatureWriter will send Features to different destinations based on an Attribute with a variable destination name.

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/fanout_about.htm

So I’ve solved the first part. I’m just using the SDE reader and breaking the table out into 363 CSV files for rooms on each floor.