Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bullish35
Contributor II

Format of People and Group SharePoint column data when loading into QlikView via RPC calls

I have been able to successfully load SharePoint list data into QlikView via RPC calls as outlined in this Wiki post: http://community.qlik.com/wikis/qlikview-wiki/reading-data-from-sharepoint-lists-into-qlikview.aspx.

However, the value of each data from People or Group type SP columns is preceded by a number and pound sign. For example, the list of Program Managers comes in like this . . .

189;#Smith,John

134;#Doe,Jane

Etc.

I just want to pull in Smith, John and Doe, Jane. Has anyone else encountered this and resolved it in their load script?

Thank you,

Ellen

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Format of People and Group SharePoint column data when loading into QlikView via RPC calls

Didn't ever load data from SharePoint, but the question looks clear. There are many ways, the easiest is probably this:
subflield('ProgramManager', '#', 2) as ProgramManager
It will return the text after the first # (and before the 2nd, which will never happen, I assume)

View solution in original post

5 Replies
mov
Esteemed Contributor III

Format of People and Group SharePoint column data when loading into QlikView via RPC calls

Didn't ever load data from SharePoint, but the question looks clear. There are many ways, the easiest is probably this:
subflield('ProgramManager', '#', 2) as ProgramManager
It will return the text after the first # (and before the 2nd, which will never happen, I assume)

View solution in original post

bullish35
Contributor II

Format of People and Group SharePoint column data when loading into QlikView via RPC calls

Thank you!

Partner
Partner

Format of People and Group SharePoint column data when loading into QlikView via RPC calls

In my opinion this is not the correct answer.  My sharepoint data has a variety of delimiters in it which I have to handle on a case by case basis using string functions like findoneof(), textbetween(), etc.  Sometimes the delimiters are in the middle of the valid text.

Anyone have any idea how to make the data come in completely clean?

Not applicable

Re: Format of People and Group SharePoint column data when loading into QlikView via RPC calls

Hi

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

qlikviewforum
Contributor II

Re: Format of People and Group SharePoint column data when loading into QlikView via RPC calls

Hi Ellen

I am also trying to load the sharepoint data into QlikView via RPC calls but I couldn't find the required link in the below post. Could you please tell me where exactly it is?

http://community.qlik.com/wikis/qlikview-wiki/reading-data-from-sharepoint-lists-into-qlikview.aspx

Thanks,

Qlikview Forum