Solved

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

  • 9 November 2021
  • 3 replies
  • 154 views

Badge

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

icon

Best answer by geomancer 9 November 2021, 18:05

View original

3 replies

Userlevel 4
Badge +36

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

Badge

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

Userlevel 4
Badge +36

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

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

Reply