Hello,
We have a dynamic straight table, meaning you have available check-boxes with column names, once selected they show up in the straight table using
=substringcount('|'&GetFieldSelections(DetailDim_, '|', 100)&'|','Column Name')
This works fine on its own, if I select one column, then we don't get any empty rows. Consider this example:
ID | Name | Viewer | Editor |
Example1 | Person1 | | |
Example1 | Person2 | | Person2 |
Example1 | Person3 | Person3 | |
Example1 | Person4 | | Person4 |
Example1 | Person5 | | Person5 |
Example1 | Person6 | | |
Empty cells are created as '', they are not null
The above table is the data we use. If i just select "ID" I will see 1 row of "Example1", as it should, but once I add to selection "Viewer", the Straight Table will look like this:
ID | Viewer |
Example1 | Person3 |
Example1 | |
I tried changing the data from '' to null, which kind of helped, with ID and Viewer selected I only get 1 row, but when I add Editor, I get 0 rows, but I would expect it to look like this:
ID | Viewer | Editor |
Example1 | | Person2 |
Example1 | Person3 | |
Example1 | | Person4 |
Example1 | | Person5 |
Any ideas how this could be achieved?