String aggregation in HDBDD

[former_member219703]

Hi,

I have a requirement to aggregate strings while creating a view in HDBDD. Requirement example is as below

Column A Column B

AA ABCD

AA WXYZ

Result should look like this

Column A Column B

AA ABCD, WXYZ

Please advise how to achieve this.

Thanks in advance,

Rosh

[akshinde]

Use STRING_AGG SQL function

[former_member219703]

I have tried but looks like STRING_AGG function is not available in HDBDD