ROW to comma Separated String in QlikView

[infosense_devel]

Hello All,

I have data as below in one of my QVD file,

Line_id

1001

1002

1003

1004

my requirement is to show data as below while loading that into QVW file.

1001,1002,1003,1004

Thanks in advance.

[Anonymous · Accepted solution]

Data:
LOAD * INLINE [
Line_id
1001
1002
1003
1004
];

Data2:
load
concat(Line_id,',') as New_line_ID Resident Data;