9 Replies Latest reply: Jul 22, 2015 2:29 PM by Marcelo Hernandes RSS

    Subfield and Distinct Issue

    Marcelo Hernandes

      Hi!

       

      I have the following table:

      Screen Shot 07-22-15 at 12.17 PM.JPG

      On QV, I'd like to see these situations:

      Screen Shot 07-22-15 at 12.17 PM 001.JPG

       

      Actually, I've achieve this merging the columns Goa1, Goal2 and Goal3 (Goal1&','&Goal2&','&Goal3 as Goal4) and then applying an subfield function, generating the field Goal Final ((SubField(Goal4,',') as Goal_Final).

       

      But I need the same resulting in a way that the expression Count(ID) is equal 5 (the same number of IDs), WITHOUT DISTINCT in the same expression.

       

      How is it possible?

       

      Tks!