Hello!
The data source is a table in Oracle Database with columns xxx, yyy, name. The number of rows around 4000 and has 9 distinct NAME values. All of the columns have VARCHAR2 format.
I use the solution there you create a bunch of collections and create one mega-collection out of it.
How I do it:
On Visible I set -
Concurrent(
ClearCollect(Digital, Filter('[S].[D_ORG]', NAME = "Digital Services")),
ClearCollect(Group, Filter('[S].[D_ORG]', NAME = "Group Management")),
ClearCollect(CX, Filter('[S].[D_ORG]',NAME = "Customer Experience"))
)
;
ClearCollect(AllStructure, Digital, Group, CX)
Seems like I get the data I needed, but if I use distinct on my mega-collection I get an error "Expected 2, recieved 1". I checked the data again and I have several values in the column I use.
Any ideas?
