Is there a way to use a counter as an increment as outlined below? Thanks

@patmhid​ We don't have anything out of the bx. If you can order your features by the grouping attribute, then you can use the Adjacent Feature option in AttributeCreator to create group counts.  I've attached an example workspace. 

You could use an Aggregator to merge on that attribite​ (add all other attributes into a list) the a normal counter. After that use a list explode to get back to the original.

Alternatively you could use a sampler to get the first feature for each of the attributes you want to count and then count the features, you can then use a FeatureJoiner to ​join the count attribute back to the rest of the data.

I'm not sure if either of these are the best option, but they will work.

@patmhid​ We don't have anything out of the bx. If you can order your features by the grouping attribute, then you can use the Adjacent Feature option in AttributeCreator to create group counts. I've attached an example workspace.

Similarly, that's the Solution I use in my Workspaces: Sorter + AttributeCreator

AttributeCreator

Enable Adjacent Feature Attributes: On

Prior Features: 1

Conditional Value: If @Value(GroupAttribute)=@Value(feature[-1].GroupAttribute) Then @Value(feature[-1].GroupID) Else @Value(feature[-1].GroupID)+1

The only thing I found was that at least in 2018.1, the FME Workspace Editor wants you to create the GroupID Attribute with a separate, preceding AttributeCreator first that initialises it to a default Dummy Value, otherwise an AttributeCreator that simultaneously tries to use Adjacent Feature Handling and create a new Attribute that doesn't yet exist in the Schema and is calculated using an Adjacent Feature Value will report itself as an "Invalid Transformer" in the workspace, even though it WILL run fine when executing the workflow!

I thought after yesterday's webinar you'd be recommending the InlineQuerier @Mark Stoakes​ :-)

select A.*, B.Rownum as Count from Table1 A,
(SELECT
    ROW_NUMBER () OVER ( 
        ORDER BY "Name"
    ) RowNum,
    "Name"
from
(select distinct("Name") from
Table1))B
where A."Name" = B."Name"

I've actually got a python based customer transformer that does the same thing that i really ought to get put on the hub

I thought after yesterday's webinar you'd be recommending the InlineQuerier @Mark Stoakes​ :-)

select A.*, B.Rownum as Count from Table1 A,
(SELECT
    ROW_NUMBER () OVER ( 
        ORDER BY "Name"
    ) RowNum,
    "Name"
from
(select distinct("Name") from
Table1))B
where A."Name" = B."Name"

I've actually got a python based customer transformer that does the same thing that i really ought to get put on the hub