Issue with sorting while using concat function with distinct qualifier

[#1]

Hi Experts,

I have three fields Item, Code and Date. I would like to concatenate distinct Code values grouped by Item and sorted by Date field. But unfortunately, the code values are sorted alphabetically. If i try sort-weight in concat function using Date field, code values are duplicated.

I tried the same in back end, still same issue. Please find the attached QVW for reference.

Thanks in advance.

[#2]

Interesting. Thank you Joe for sharing this knowledge.

[#3]

no worries, glad to help

[ngetal_93]

Hello Devaki,

You were saying earlier "For example for item 3, MER repeats after few codes then it should be MER-->ABC-->FHJ-->NUD-->HJD-->MER"

I would like to obtain the same result but I don't see it in the solutions found. Have you been able to do it ?

Thanks in advance,

Matthieu Junier