Skip to main content

Hi,

I want to group materials and pipe length according to different age barckets (of say 2 or 5 or 10 years)...how could i do in FME?

Please see my sample data:



Hi @ppp19​ 

 

Your source data is not here.


Hi @danilo_fme​ 

Attached snapshot from my data!


If you want to group by year you should first extract the value of the year.

Use DateTimeConverter set with Input Format %d/%m/%Y and Output Fomat %Y.

Than use AttributeRangeMapper. Use the Generate button to auto-create your ranges (input a min, max year and the number of ranges - do the math for 2, 5, 10 years).

Use the value of the range attribute (_looked_up by default) to group features


If you want to group by year you should first extract the value of the year.

Use DateTimeConverter set with Input Format %d/%m/%Y and Output Fomat %Y.

Than use AttributeRangeMapper. Use the Generate button to auto-create your ranges (input a min, max year and the number of ranges - do the math for 2, 5, 10 years).

Use the value of the range attribute (_looked_up by default) to group features

Hi @caracadrian,

That worked perfectly according to my expectations. Thank you so much for your help.

Regards


Reply