+9Hi,
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.
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.
+9Hi @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
