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:
Userlevel 4
+30
- Evangelist
- 1880 replies
-
21 July 2021
Hi @danilo_fme
Attached snapshot from my data!
+20
- Contributor
- 564 replies
-
22 July 2021
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.