I'm looking for an automatic way to omit a column if every value is null. I've looked worked with elaborate workflows using transposes, summations, and cross tabs; as well as dynamic select which is where I believe my solution is. I tried using the expression:
!IsNull([IsNumeric]) || !IsNull([IsString])
but that didn't work. It would be nice to apply that function to all columns rather than include each in an OR statement, but I don't know how to do this.
If the input is this:
| Line Item | Info | ID | UPC | Note |
| 1 | i1 | 245 | | |
| 2 | i2 | | | |
| 3 | i3 | | | |
| 4 | i4 |
362 | | |
| 5 | i5 | | | |
then the result would be this:
| Line Item | Info | ID |
| 1 | i1 | 245 |
| 2 | i2 | |
| 3 | i3 | |
| 4 | i4 | 362 |
| 5 | i5 | |
