How can I add a new row for a time series data preparation?

[ipazin]

Hello @LilianaGarcia,

you can try Pivoting/Unpivoting trick. See here:

Add Row based on filters

Hello everybody, I am looking for a solution as follows. I am extracting data into a table and group it by Code and period. That is fine and it works. But sometimes I have for some codes not the same number of rows. That is something I need. How can I loop through the table and add a row, to but values into the specific fields. Here a short example. row ID Code period OK NOK HIGH RISK STATUS Row0 123 2019/01 135 26 0 3 Row1 123 2019/02 137 24 0 3 Row2 123 2019/03 135 26 0 3 Row3 …

Br,
Ivan