Skip to main content
Solved

Attribute from Next Feature

  • November 14, 2025
  • 7 replies
  • 49 views
kevink
Contributor
Forum|alt.badge.img+3

I have the following table, very simple:

DATE_START ID
19921101 0502010000013950
19950209 0502010000013950
20031231 0502010000013950
20040115 0502010000013950
20040120 0502010000013950
20110704 0502010000013950
20200211 0502010000013950
20251005

0502010000013950

 

I want to make te following result:

 

DATE_START DATE_END ID
19921101 19950209 0502010000013950
19950209 20031231 0502010000013950
20031231 20040115 0502010000013950
20040115 20040120 0502010000013950
20040120 20110704 0502010000013950
20110704 20200211 0502010000013950
20200211 20251005 0502010000013950
20251005 null 0502010000013950

 

Date_end is next value of date_start to create a cycles like this. This what i did:

 

 

 

 

I get to following result:


U see the problem is with the last date_end, he is using for that feature the first date_start. I dont now how.

 

Anyone a solution?

Best answer by ebygomm

 

    7 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+45
    • ebygommInfluencer
    • Influencer
    • November 14, 2025

    You should be able to use a conditional formula, so only set the date if the id matches the adjacent feature

    kevink
    Contributor
    Forum|alt.badge.img+3
    • kevinkContributor
    • Author
    • Contributor
    • November 14, 2025

    How do you mean, what do i fill in the conditional formula?

    ebygomm
    Influencer
    Forum|alt.badge.img+45
    • ebygommInfluencer
    • Influencer
    • Best Answer
    • November 14, 2025

     

    nielsgerrits
    kevink
    kevink
    Contributor
    Forum|alt.badge.img+3
    • kevinkContributor
    • Author
    • Contributor
    • November 14, 2025

    THANKS!

    s.jager
    Influencer
    Forum|alt.badge.img+21
    • s.jagerInfluencer
    • Influencer
    • November 14, 2025

    You should be able to use a conditional formula, so only set the date if the id matches the adjacent feature

    But should that be necessary when you use Group By? Of course it will work, and provides a solution for the OP, but tbh I don’t think it should be necessary… if it is, I think I would consider that a bug. Because the Group By should make sure the end date is only filled within the group, or am I seeing that the wrong way?

     

    Oh duh… attributecreator of course doesn’t support Group By. Guess I need a coffee break...

    ebygomm
    Influencer
    Forum|alt.badge.img+45
    • ebygommInfluencer
    • Influencer
    • November 14, 2025

    You should be able to use a conditional formula, so only set the date if the id matches the adjacent feature

    But should that be necessary when you use Group By? Of course it will work, and provides a solution for the OP, but tbh I don’t think it should be necessary… if it is, I think I would consider that a bug. Because the Group By should make sure the end date is only filled within the group, or am I seeing that the wrong way?

    The group by shown is on a sorter, nothing to do with the adjacent attribute handling 

    s.jager
    Influencer
    Forum|alt.badge.img+21
    • s.jagerInfluencer
    • Influencer
    • November 14, 2025

    The group by shown is on a sorter, nothing to do with the adjacent attribute handling 

    No, I realized that about 3 seconds after hitting Send… sorry for the Spam!

    Community Stats

    32,127
    Posts
    121,960
    Replies
    39,777
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.