Skip to main content
  • EN

Hello,

I have summary output coming from the StatisticsCalculator that I would like to rearrange such that row values become column headings with values for these coming from the statscalc count output (see input and end result images below). I've tried AttributePivoter, AttributeTransposer without success.

Thanks.

Tony

Hi @aviveiro, try this.

Firstly create a new attribute whose name is equal to the value of STOCKING and assingn the value of STOCKING_count to the new attribute, with the AttributeCreator as in:

Then, aggregate all the features using the Aggregator with Merge Incoming Attributes mode.

Finally expose the new attribute names (originally equal to values of STOCKING) with the AttributeExposer, then remove unnecessary attributes optionally.

The workflow looks like this.

Hi @aviveiro, try this.

Firstly create a new attribute whose name is equal to the value of STOCKING and assingn the value of STOCKING_count to the new attribute, with the AttributeCreator as in:

Then, aggregate all the features using the Aggregator with Merge Incoming Attributes mode.

Finally expose the new attribute names (originally equal to values of STOCKING) with the AttributeExposer, then remove unnecessary attributes optionally.

The workflow looks like this.

If you need to change Softwood and Hardwood to their abbreviation SW and HW, perform changing them before the AttributeCreator.

Hi @aviveiro, try this.

Firstly create a new attribute whose name is equal to the value of STOCKING and assingn the value of STOCKING_count to the new attribute, with the AttributeCreator as in:

Then, aggregate all the features using the Aggregator with Merge Incoming Attributes mode.

Finally expose the new attribute names (originally equal to values of STOCKING) with the AttributeExposer, then remove unnecessary attributes optionally.

The workflow looks like this.

Terrific @takashi!

One thing I did have to do was manually type in the new attribute names (originally equal to values of STOCKING) in AttributeExposer because I didn't see them as attributes to expose.

Thank you.

Tony

Reply


Community Stats

31,819
Posts
120,867
Replies
39,454
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.