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,
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:
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