Hi everybody,
I have a table like this:
| ID | Name | From Date | To Date |
|---|---|---|---|
| 1 | PLAN | 2024 | 2026 |
and I want to change it to this :
| ID | Name | year |
|---|---|---|
| 1 | PLAN | 2024 |
| 1 | PLAN | 2025 |
| 1 | PLAN | 2026 |
any suggestion?
thanks in advance
You can solve this with just a few nodes - let me introduce the “One Row To Many” Node:
Here is the workflow - should be fairly straight forward - one row to many replicates your one row a certain number of times (in this case To-From+1-times) and then you can calculate your year column based on the To-date + the index of each row…
expand.knwf (53.7 KB)
2 Likes
Wow!! GREAT man! Yeah, One row to many is indeed the solution here. thanks
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.