Hello,
currently i am summarize a table with input from multiple files. How can i remove blank rows from output table -
Current Output-
Items | january | february | march | april | may | june | july | august | september | october | november | december |
A | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
B | 4 | 6 | 7 | 8 | 9 | 12 | 15 | |||||
C | 4 | 5 | 6 | 7 | 8 | 10 | 11 | 12 | 14 | 15 | ||
D | ||||||||||||
E | ||||||||||||
F | ||||||||||||
G | ||||||||||||
H | ||||||||||||
I | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
J | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
K | ||||||||||||
L | ||||||||||||
M | ||||||||||||
N | 4 | 5 | 6 | 7 | 8 | 10 | 11 | 13 | 14 | |||
O | 5 | 7 | 8 | 9 | 10 | 12 | 13 | 15 | ||||
P | 4 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 14 | 15 |
Expecting Output(No Blank Rows) -
Items | january | february | march | april | may | june | july | august | september | october | november | december |
A | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
B | 4 | 6 | 7 | 8 | 9 | 12 | 15 | |||||
C | 4 | 5 | 6 | 7 | 8 | 10 | 11 | 12 | 14 | 15 | ||
I | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
J | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
N | 4 | 5 | 6 | 7 | 8 | 10 | 11 | 13 | 14 | |||
O | 5 | 7 | 8 | 9 | 10 | 12 | 13 | 15 | ||||
P | 4 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 14 | 15 |
Solved! Go to Solution.
I'm sure there's a better solution, but I would do is:
Another option would be to use a Filter where you say
!isnull(January) and !isnull(February) ....
for all the months but that seems less than ideal
Hi @flying008
can you please provide the workflow for this. this illustration is not clear
Hi, @kauser
Due to security policy restrictions, I am unable to upload any WF, so please try it yourself according to the tool process in the animation.
@kauser take a look at the attached workflow that should do the trick. LEt me know how you get on
@kauser one way of doing this.