Hey there.

If I understand correctly, you want to create a full list with all years even if they’re not included in your data. If the year isn’t included in your data, you want the year count to be 0.

You can do this by

1. creating a list of possible years and set each total to 0 (I would use excel)
2. then join the two lists by year using a featurejoiner. When conflicts with the job count occurs, use the count attribute from your data.
3. You should now have a list with all years and a count of zero for the years that weren’t in your original list

--

If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This marks the post as answered and helps the community find the solution. If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂

Thanks @carmijo​, yes I want to create a full list, where the years not in the data are assigned a value of zero.

I think it might be something to do with the ID field or the Year field type not matching.

Unfortunately your approach did not give me the results that I need but I will keep trying.

Take a look at the solution to this question. I think you can adapt the solution to your needs.

Thanks that is what i was trying to work with but just can't get the right answer. I think it is because I need it to be based on two attributes, the id and year. I need 5 records for each id so might just need a range of feature merges and joins.​

There is always a way 😉

No need for several feature mergers. Create the 5 years for each site by taking each individual site, cloning five times and then creating the year from the copynumber and starting year. Then featuremerge on Site Number and Year and keep only unmerged years (i.e. those not previously included in the data)

Thanks ​@geomancer​ very much appreciated and as you said there is always a way.

Thanks @ebygomm​ your assistance is always appreciated ​