Forum Discussion
extend table information / omitting redundant information
Hello, I have a table with historical data where each entry (ID) has date and a corresponding state. 1234 01.01.2020 True 1234 02.01.2020 True 1234 03.01.2020 True 9999 01.01.202...
Sorry, I think I didn't make myself clear. I know how to sort the values out. I actually want the opposite. To get from a single line in the table to multiple.
from:
| 1234 | 01.01.2020 | True |
to this:
| 1234 | 01.01.2020 | True |
| 1234 | 01.02.2020 | True |
| 1234 | 01.03.2020 | True |
| ... | .... | ... |