Skip to main content
Solved

Fill rows by empty date


mr_fme
Enthusiast
Forum|alt.badge.img+9

Hi,

 

See my data below, I have lines that are grouped by countries, but each country has a rows that starts on April 1, but there is no rows in the last few days. You want to double the missing days, take the parameter from the previous day and fill in the missing data automatically, until the last day of May.

Can you help me with that?

 

Input data:

Current:

 

Expected:

 

 

Thank´s

 

Sorato

Best answer by takashi

Hi @mr_fme, try this workflow. If you need to preserve the original order, expose xlsx_row_id in the Excel reader feature type and add another Sorter at the end of the workflow to sort the features by xlsx_row_id and Information date.

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

2 replies

takashi
Evangelist
  • Best Answer
  • May 13, 2020

Hi @mr_fme, try this workflow. If you need to preserve the original order, expose xlsx_row_id in the Excel reader feature type and add another Sorter at the end of the workflow to sort the features by xlsx_row_id and Information date.


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • May 14, 2020
takashi wrote:

Hi @mr_fme, try this workflow. If you need to preserve the original order, expose xlsx_row_id in the Excel reader feature type and add another Sorter at the end of the workflow to sort the features by xlsx_row_id and Information date.

Thank´s @takashi


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