Help Needed !

[kiranpatil123]

Hi All , 

i have below data set flowing  ( Both columns in same Table )

ID	Article Name
1	WW
1	QE
2	SS
3	QZ
3	QC
3	QN
4	QE
5	KK
6	JH
6	LM
6	TT
6	PP

and i need to achieve as below in front end or Back end how to be done.

ID	Article Name
1	WW/QE
2	SS
3	QZ/QC/QN
4	QE
5	KK
6	JH/LM/TT/PP

Pleaes help

Advance Thank:) 

[martinpohl · Accepted solution]

Hi!

usethis:

Data:
LOAD * INLINE [
ID, Article Name
1, WW
1, QE
2, SS
3, QZ
3, QC
3, QN
4, QE
5, KK
6, JH
6, LM
6, TT
6, PP
];

Data_new:
NoConcatenate
load
ID,
Concat("Article Name",'/',) as "Article Name"
resident Data
group by ID;

drop table Data;

[kiranpatil123]

Thanks Martin ,
It worked 🙂