Dashboard Graph to - Create unique categories from a Markets column that contains multi values

Splitting lists or arrays into rows is not one of the strongest points of Sisense Elasticubes -- the value from this column will get imported as a single text value. You _can_ then isolate the first, second, third... etc value using string manipulation functions but doing this exhaustively means knowing the maximum number of values you can have in this array and repeating the isolation that many times (and unioning all the results)

Like this:

select id, StrParts(Market, ';#', 0) as market from Sheet1 where not IsNullOrEmpty(StrParts(Market, ';#', 0)) 
union all 
select id, StrParts(Market, ';#', 1) from Sheet1 where not IsNullOrEmpty(StrParts(Market, ';#', 1)) 
union all
select id, StrParts(Market, ';#', 2) from Sheet1 where not IsNullOrEmpty(StrParts(Market, ';#', 2)) 
union all 
select id, StrParts(Market, ';#', 3) from Sheet1 where not IsNullOrEmpty(StrParts(Market, ';#', 3)) 
union all
select id, StrParts(Market, ';#', 4) from Sheet1 where not IsNullOrEmpty(StrParts(Market, ';#', 4)) 

You might be better off making use of Excel tooling  (maybe even PowerQuery) to create the expansion table that has multiple rows for every rowid (or unique identifier) table row in your main table, and all the values in your 'Market' field so that there is a *single* value in the Market field. Then import both (/all three) tables into Sisense and join them on the rowid in your cube/model.

Something like:

1. Austria
1. Germany
2. Austria
2. Germany
2. Belgium/Lux
2. Czech Repblic