Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy!
I have following table:
Tour | OrderNb. |
1234567 | 123 |
1234567 | 123 |
1234567 | 789 |
1234567 | 789 |
9876543 | 456 |
9876543 | 369 |
9876543 | 456 |
9876543 | 369 |
Now I want to summarize each tour on one line.
BUT concat OrderNb. without duplicates for a better view:
Like:
Tour | OrderNb. |
1234567 | 123; 789 |
9876543 | 456; 369 |
Do you have any idea?
Thank you!
Hi
Try using the following
Concat(Distinct OrderNb. , '; ')
Regards
Adrian
Hi
Try using the following
Concat(Distinct OrderNb. , '; ')
Regards
Adrian
Ouch, you're right.
Sometimes the simplest solution is the hardest 😁