This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The idea is to generate all possible combinations of years (lower - higher) with left side being lower value and right side being higher and then subtract right from left value. These values need to be dynamic based on data. Also all possible combinations (lower to higher) needs to be there starting with smallest year to largest year.
Using tools like Append quickly creates huge data, so the idea is to have as efficient solution as possible...
Because the Join tool and the Append Fields (cross join) Tool do not allow for non-equijoin (where the join condition is not equal to) there is not a way to do this natively in Atleryx. You must first join, then filter where "year_1" < "year_2". If the amount of data being processes is an issue, you can strip all extraneous columns off of the data, create a list of year combinations that meet your criteria, then join back any attributes needed after the combinations are created.