Event label in Query

[Fijka_Mook]

Hello,
I have a query with column ‘Event label’. When all the specimens in the result have the same ‘Event label’, I see one column named ‘Event label’. But when the specimens in the result have different ‘Event labels’, I see multiple columns like ‘Event label’, ‘Event label - 1’ and so on. This is not what I expected. Every specimen belongs to only one event and this way I can’t see what event that is. Is there a way to get the right and only the right event in the query result?

[Lee_Ann]

Hi Fijka

When you define your columns you need to check the visit identifier. Then it will pull the correct visit label.

Thanks
Lee

[Fijka_Mook]

Thank you!