Hi Guys,
How can I split the row and create a new row?
For example. I have this data.
As you can see in Column6 there are rows that need to split, rows 2 and 4.
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 |
Test1 | RQS | D | 1999/01/25 | 4604 | 1 | |
Test2 | SDF | D | 1999/01/25 | 0444 & 4604 (split 50 / 50) | 1 | |
Test3 | GGS | D | 1999/01/25 | 4605 | 1 | |
Test4 | ASB | D | 1999/01/25 | 0444 & 4604 (split 50 / 50) | 1 |
The final output must be something like this,
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 |
Test1 | RQS | D | 1999/01/25 | 4604 | 1 | |
Test2 | SDF | D | 1999/01/25 | 444 | 0.5 | |
Test2 | SDF | D | 1999/01/25 | 4604 | 0.5 | |
Test3 | GGS | D | 1999/01/25 | 4605 | 1 | |
Test4 | ASB | D | 1999/01/25 | 444 | 0.5 | |
Test4 | ASB | D | 1999/01/25 | 4604 | 0.5 |
Also when splitting rows, Column 7 must be equally distributed to split rows.
Solved! Go to Solution.
Please see below:
Hope this helps!
If this solve the need please mark it as solved, it will help others.
Attached the workflow,
Regards