I've done this once, but I am on an ITSM/CSM project and I am not with BMC Discovery product for now. During the working day, I can't help much.
If I am not mistaken, it is with explodes that you will solve your problem. You will have to place the explode within another function. But, to help you precisely I have to upload a VM with Discovery to test here.
I will share this post with Lisa Keeler, maybe she can help you here
PS: Are you at Vale do Rio Doce?
1 of 1 people found this helpful
Thanks a lot! I just found out that the issue was not on the Explode function, because it doesn't remove the entries with only one value
Problem solved with another query
PS: yes, I work at Vale
Hi Jessiele, Can you please share the query that worked for you. Thanks.