Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, need a little help on my very specific request.
I am recovering quality data namely a line of data by default and by vehicle number. I am attaching the file.
My objective is to use a filter field to select the identification number and I would like the defects of this number to be written in list.
I explain myself:
If we choose the number for example 129872, I would like that in my table element that there are not several lines for each defect but rather a single line that groups the defects with a separation by a comma:
- Parts missing , Parts Broken
Thanks in advance and have a nice day
You simply need to use the CONCAT function which will concatenate other fields at the dimensional value level.
Concat([Type de défaut], ', ')
Here is example