1 Reply Latest reply on Jan 10, 2014 3:48 AM by Lucian Alexe

    Search for multiple strings and display them in one cell

    Lucian Alexe

      Hello there,

       

      I'm pretty new to this software, just started to experiment with it. I'm preparing to do a bigger project so now I'm in the testing phase.

      I have this database that is formatted like this:

       

      CountryIDType
      Afghanistan
      1
      Contraception
      Bangladesh2
      Retroviral
      Bangladesh2
      Contraception
      Bangladesh
      2ARV

       

      My goal is to return all the strings from the "Type" field for the same "ID" value and put them in a "Tooltip" on a map.

      So far, this is what I've accomplished, with the use of <ATTR(Type)>. It works well for 1 value, but for the countries that have multiple values I get an asterisk...

      Is this a formatting problem? Thanks for any suggestions...

       

      1.jpg

       

      2.jpg

       

      3.jpg