Hi everyone
if anyone has any ideas about how to resolve the following please:
I am pulling data from a Sharepoint site
there are a few fields which are set up as Checkboxes and these fields can be multi select e.g. the country field
If i pull this field into Qliksense in a normal load, the country field is displayed as "SYSTEM.String[]"
Table1:
LOAD
ID,
FIELDNAME AS COUNTRY
FROM SHAREPOINT SITE;
RESULTS
ID COUNTRY
1 SYSTEM.String[]
-----
I am trying to resolve this by using SubField() function in the LOAD Script
e.g.
Table 2:
LOAD
"ID",
Subfield(Country,','1) as CountrySplit
however it looks like the field is being brought through with all values as SYSTEM.STRING[] so this subfield doesnt work, and if i do a SubStringCount('[') it will return 1 as it picks up the bracket
any ideas how i can get the country to display or be brough back as a country list e.g. one of the values is italy,UK,USA?
thanks very much