Separator for multi-value fields of Sharepoint lists extracted with Qlik Office 365 Sharepoint Connector
Is it possible to change the separator for extracts of multi-value fields (data type 'choice') from Sharepoint lists, using the Qlik Web Connector?
With the Qlik Office 365 Sharepoint Connector, I'm reading a Sharepoint list using the 'ListItemsFromID' function. For multi-value fields, it separates the values with a comma. As the valueset contains text strings which also contain commas, it is complicated to separate the individual values. Hence it would be helpful if there is an option to change the separator, eg. from a comma to a pipe.