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
  • 998 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

View original
Did this help you find an answer to your question?

3 replies

geomancer
Evangelist
Forum|alt.badge.img+47
  • Evangelist
  • 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
  • November 11, 2021

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


geomancer
Evangelist
Forum|alt.badge.img+47
  • Evangelist
  • November 11, 2021
eva218 wrote:

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

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings