Variable storing multiple material number seperated by comma

[#1]

Dear friends

I want to use a variable in set analysis which contains the list of material number seperated by comma for a selected supplier.

Can we store multiple material number for a selected supplier in a variable , the number should be seperated by comma.

Pls do share comments or suggestions

Many thanks

Rahul

[Gysbert_Wassenaar · Accepted solution]

If you select only one supplier something like concat(distinct material_number, ',') would create a concatenated list of comma separated material numbers for that supplier. Replace material_number with the name of the field that contains the material numbers.

[#3]

Hi Gysbert

Many Thanks!

It works perfectly.

Rahul Kale