Field Concatenation

[brindlogcool]

I want to concatenate district and product columns like this District (P1,P2,P3). District,P1,P2,P3 are individual columns.

The problem here is always not all the P1,P2,P3 will not have values . So there can be scenarios as below

District --- No product so it should display  District

District ,P1 is NULL, P2,P3 --- District (P2,P3)

I tried to concatenate it is coming with blanks as District (,P2,P3)

I tried to loop through and create tables but it is creating multiple tables and not working

[Gysbert_Wassenaar · Accepted solution]

Try: District & replace(replace(replace( '(' & alt(dual(P1,1), '#') & ',' & alt(dual(P2,1), '#') & ',' & alt(dual(P2,1), '#') & ')' , ',#', ''), '#,', ''),'()','')

[brindlogcool]

Perfect solution.... Thank you so much