Finance | Project Operations, Human Resources, ...

Remove duplicates and concatenate strings

(0) Share

Report

Posted on by D365 beginner

634

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.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

MCallebert 45 on at

Like (0)

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

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report

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

Was this reply helpful? Yes No