Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
darren_dixon
Contributor III
Contributor III

Change multiple records into one record.

Hi

Code:

SELECT TOP 1000 [UserName]

      ,[PropertyName]

      ,[Value]

  FROM [1stTouch_Live].[Profile].[UserProperties]

  where UserName='SHG\jim.Graham'

Result:

UserNamePropertyNameValue
SHG\jim.grahamAgencyGEN
SHG\jim.grahamMaximum Scheduled Tasks1
SHG\jim.grahamOperative nameJim Graham
SHG\jim.grahamDispatch ModeResponsive
SHG\jim.grahamServer InstanceOptiTime
SHG\jim.graham_ResourceID208
SHG\jim.grahamStockHolderID1
SHG\jim.grahamStore1
SHG\jim.grahamSupervisor nameChris Hope
SHG\jim.grahamSupervisor number
SHG\jim.grahamVanIDD256
SHG\jim.grahamView Key Fields On Disabled Taskstrue
SHG\jim.grahamVolumeK
SHG\jim.grahamWorkDayBoundaryTime05:00:00

How can I change this to be

UsernameAgencyMaximum Scheduled TasksOperative name





SHG\jim.grahamGEN1Jim Graham





Thanks,
Darren

1 Solution
2 Replies
darren_dixon
Contributor III
Contributor III
Author

Fantastic. Thank you very much!!