Sharepoint Multi checkbox List field issue

CraigF — Mon, 13 Dec 2021 16:54:51 GMT

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

topic Sharepoint Multi checkbox List field issue in Connectivity & Data Prep

Sharepoint Multi checkbox List field issue