Forum Discussion
Remove blank rows in an array
Hello I'm trying to remove blank rows from an array, attached an image to better understand it. If you look at this matrix you are grouping ledger accounts by levels, below account "13050505 - ...
Hello @TaylorN ,
Attach the image below.
He removes them because I have a fact board like this:
SkCuenta Company Must have
1 5 100 0
1 6 50 0
And my dimension table, with which I'm doing the levels in the matrix is like this:
SkCuenta Nivel1 Nivel2 Nivel3 Nivel4 Nivel5 Nivel6
5 1 13 1305 13050 13050505 (Level 6 blank)
If I don't see level 6, the fact table line with the skAccount-5 is as if it is not binding.
A greeting
Hello! Good morning!
I have the same problem! Have you found a solution for it?
Thank you!
Joseph.