Hi Guys,
I am working on a data that has more that 10,000 rows, that requires me to add a blank row in between the data sets that I have. Can someone guide me on this.
Example:-
My input is.
A | 100 |
B | 200 |
C | 300 |
D | 400 |
E | 500 |
F | 600 |
G | 700 |
H | 800 |
Output required
A | 100 |
B | 200 |
C | 300 |
D | 400 |
E | 500 |
F | 600 |
G | 700 |
H | 800 |
Solved! Go to Solution.
Here is a simple way.
Put in a record ID field - then create one stream with only the record ID. Union it back to the original, sort, then remove the record ID with the select.
You might need to watch the output order on the union to get the blanks before or after.
Hi RajayKumar,
My approach would be the following: I would use the generate rows tool.
Please find the workbook attached.
Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!
Best,
Diego