Skip to main content
Solved

How can I add new rows in my table and chose the values in these new rows?

  • November 9, 2021
  • 3 replies
  • 1222 views

Forum|alt.badge.img

Hello,

I have the feeling that I want to do something very simple, and probably the answer is simple as well 😅 But I just don't know how to accomplish the following:

I have a column named Period with the following values

2017-01

2017-02

2017-05

2017-06

2017-09

2017-10

2017-12

How can I add rows with the missing periods, so that I obtain the following table:

2017-01

2017-02

2017-03

2017-04

2017-05

2017-06

2017-07

2017-08

2017-09

2017-10

2017-11

2017-12

I don't necessarily need to automate this. So I am ok with typing in the new values (2017-03, 2017-04, 2017-07, 2017-08, 2017-11) in a transformer. But which transformer do I need for this?

 

Thanks in advance,

Eva

Best answer by geomancer

To let FME do most of the work, you can use a Creator and an AttributeManager to create all possible values, as shown on the bottom row of this workspace.

Then use a FeatureJoiner (with Join Mode set to Full) to merge them with the existing values.

Image of Workspace Add_missing_periods

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • Best Answer
  • November 9, 2021

To let FME do most of the work, you can use a Creator and an AttributeManager to create all possible values, as shown on the bottom row of this workspace.

Then use a FeatureJoiner (with Join Mode set to Full) to merge them with the existing values.

Image of Workspace Add_missing_periods


Forum|alt.badge.img
  • Author
  • 21 replies
  • November 11, 2021

Thank you very much @geomancer​. It works great!


geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • November 11, 2021

Thank you very much @geomancer​. It works great!

Hi @eva218​ , I'm glad to hear it works for you 😊