topic Re: RE:Rows to Data in QlikView

RE:Rows to Data

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have data like below in Database file

INPUT:

Employee Table:

ExmName EmpId Location

AA 101 BANGLORE

AA 101 MUMBAI

AA 101 CHENNAI

BB 102 BANGLORE

CC 103 CHENNAI

CC 103 HYD

DESIRED OUTPUT:

ExmName EmpId Location

AA 101 BANGLORE,MUMBAI,CHENNAI

BB 102 BANGLORE

CC 103 CHENNAI,HYD

how can i achieve this?

Gysbert_Wassenaar — Tue, 06 Dec 2016 11:16:12 GMT

Create a straight table with ExmName and EmpId as dimensions and as expression concat(Location, ',')

Or if you want to do it in the script:

Result:

LOAD ExmName, EmpId, concat(Location, ',') as Locations

RESIDENT INPUT

GROUP BY ExmName, EmpId;

Chanty4u — Tue, 06 Dec 2016 11:22:41 GMT

Thanks .It works as expected