Change multiple records into one record.

[darren_dixon]

Hi

Code:

SELECT TOP 1000 [UserName]

      ,[PropertyName]

      ,[Value]

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

  where UserName='SHG\jim.Graham'

Result:

UserName	PropertyName	Value
SHG\jim.graham	Agency	GEN
SHG\jim.graham	Maximum Scheduled Tasks	1
SHG\jim.graham	Operative name	Jim Graham
SHG\jim.graham	Dispatch Mode	Responsive
SHG\jim.graham	Server Instance	OptiTime
SHG\jim.graham	_ResourceID	208
SHG\jim.graham	StockHolderID	1
SHG\jim.graham	Store	1
SHG\jim.graham	Supervisor name	Chris Hope
SHG\jim.graham	Supervisor number
SHG\jim.graham	VanID	D256
SHG\jim.graham	View Key Fields On Disabled Tasks	true
SHG\jim.graham	Volume	K
SHG\jim.graham	WorkDayBoundaryTime	05:00:00

How can I change this to be

Username	Agency	Maximum Scheduled Tasks	Operative name
SHG\jim.graham	GEN	1	Jim Graham

Thanks,
Darren

[rwunderlich · Accepted solution]

Use "Generic Load". See

http://qlikviewnotes.blogspot.com/2010/05/use-cases-for-generic-load.html

-Rob

http://masterssummit.com

http://robwunderlich.com

[darren_dixon]

Fantastic. Thank you very much!!