3 Replies Latest reply: May 15, 2014 9:59 AM by Grant Perkins RSS

    Establishing more than 1 criteria for given column

    diajus _

      Is there a way to query a specific column and select 1 of 2 possible outcomes?  For example if I had a column that Displayed rows of Citys and I only wanted to query Los Angeles and San Antonio. Could I create a template that appends the records creating one unique table of columns? I would like the data to be displayed as follows.

       

      A

      Los Angeles

      San Antonio

      San Antonio

      Los Angeles

       

      I created a second template and the records are appending however a new column "B" was created and the data is not in the one column format that I described above.