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

    Subfield and Distinct Issue

    Marcelo Hernandes



      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?