Post reply

How do I combine multiple rows into one (each column has different value) ?

  • March 1, 2018 at 10:04 am

    #410282

    I need help on getting another query to wrap the results from this query. The actual data has more columns (fields) than I have shown here. 

    How can I come up with one ticket number per row  and each column could fill the value of 'Yes' or 'N/A' in the appropriate columns?

    The end result should be one ticket # per row.

  • March 1, 2018 at 10:15 am

    #1981665

    Tamrak - Thursday, March 1, 2018 10:04 AM

    I need help on getting another query to wrap the results from this query. The actual data has more columns (fields) than I have shown here. 

    How can I come up with one ticket number per row  and each column could fill the value of 'Yes' or 'N/A' in the appropriate columns?

    The end result should be one ticket # per row.

    SELECT number
      , Mandatory = MAX(Mandatory)
      , Valid = MAX(Valid)
      , ....
    FROM ...
    GROUP BY number

    How to post data/code on a forum to get the best help.

  • March 1, 2018 at 10:23 am

    #1981669

    Thank you very much. That's work great.

  • March 1, 2018 at 10:24 am

    #1981670

    DesNorton - Thursday, March 1, 2018 10:15 AM

    Tamrak - Thursday, March 1, 2018 10:04 AM

    I need help on getting another query to wrap the results from this query. The actual data has more columns (fields) than I have shown here. 

    How can I come up with one ticket number per row  and each column could fill the value of 'Yes' or 'N/A' in the appropriate columns?

    The end result should be one ticket # per row.

    SELECT number
      , Mandatory = MAX(Mandatory)
      , Valid = MAX(Valid)
      , ....
    FROM ...
    GROUP BY number

    Thanks for quick response.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply