Hello, I have started using DataView cards. I have prepared the following query :
TABLE WITHOUT ID
link(rows.file.link,rows.pn_plant) as "Agrati PN",
embed(link(img_product,"1")) as "Draft",
rows.pn_customer as "PN Customer",
rows.customer as "Customer",
rows.desc_product as "Desc. Prod.",
rows.samples_location as "Location of Samples"
FROM "002-Presviluppo_&_Feasability"
where (type = "proto" or type="presviluppo") and status=5
GROUP BY img_product
SORT pn_plant ASC
Would like the pn_plant to appear only once, since, as you can see from the image, it currently appears a number of times equal to its repetitions in the notes, below the output :
Thank you for your support.
