Finance | Project Operations, Human Resources, ...

Remove duplicates and concatenate strings

(0) Share

Report

Posted on by D365 beginner

578

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.

All responses (2)

Answers (0)

MuthukumaranAX 2,901 on at

Like (0)

Report

RE: Remove duplicates and concatenate strings

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
Suggested answer

MCallebert 45 on at

Like (0)

Report
RE: Remove duplicates and concatenate strings

You can use something like that :
str1260 yourItemids; yourtable yourtable; while select itemid from yourtable group by yourtable.itemid { yourItemids = strfmt(",%1", yourtable.itemid)); }