Announcements
No record found.
Hi Experts,
In my custom table I have some data as shown below, I need to remove the duplicates, concatenate the values having comma in between and display it in a report. Any help would be appreciated.
ItemId
Item1
Item2
I need to display the result as Item1,Item2.
Thanks in advance.
You can use something like that :
str1260 yourItemids; yourtable yourtable; while select itemid from yourtable group by yourtable.itemid { yourItemids = strfmt(",%1", yourtable.itemid)); }
you can follow MCallebert instruction to concatenate the string and you can do group by in the select statement to avoid duplicate values being selected
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 606 Super User 2026 Season 1
CP04-islander 356
