Name column derived from SharePoint displays number as its values

[apoorvasd]

Hello Everyone,

I am pulling data from SharePoint list into QlikView, where this list is first exported to MS access and then QlikView pulls data from it.

I am facing an issue w.r.t. "Name" field, where the names are displayed in number format in QlikView which are actually text values.

For example, if column, "Modified By" in SharePoint has A, B, C as its values, when I call this field in to QlikView "Modified By" has 1, 2, 3 as its values. But I would want these to be displayed in text format in QlikView too.

Any help on this?

Thank you.

[apoorvasd]

Hello,

Thank you so much for all your inputs!

May be I will try to ask the SharePoint team to provide one more column (only for QlikView) which would have the names in text format and see if this works!

Thank you.

[Amoon666]

Hi,

I currently face the same issue and would like to know how you resolved it.

Thank you

[David8733]

---

@apoorvasd wrote:

Hello Everyone,

I am pulling data from SharePoint list into QlikView, where this list is first exported to MS access and then QlikView pulls data from it.

I am facing an issue w.r.t. "Name" field, where the names are displayed in number format in QlikView which are actually text values. mymilestonecard

For example, if column, "Modified By" in SharePoint has A, B, C as its values, when I call this field in to QlikView "Modified By" has 1, 2, 3 as its values. But I would want these to be displayed in text format in QlikView too.

Any help on this?

Thank you.

---

Is there a table where the field values and numbers are filled? I mean the "modified by" description is probably a user or employees table or something in that direction.