Forum Discussion
change Record column to Display Name
Hello.
How I can change Record value in my column Author to Display Name in my report?
This is what I see in Transform data window
And I need Full Name of an author column in my SharePoint list.
Hi Anonymous
I'm not entirely clear on what you need, what do you mean by Full Name ? But I think you want to get the Title from the Record in the column?
If so, add a custom column and enter this in the dialog box
= try [Author][title] otherwise nullPhil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
1 Reply
- PhilipTreacy
Super User
Hi Anonymous
I'm not entirely clear on what you need, what do you mean by Full Name ? But I think you want to get the Title from the Record in the column?
If so, add a custom column and enter this in the dialog box
= try [Author][title] otherwise nullPhil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.