3 Replies Latest reply on Nov 18, 2016 12:51 AM by shravang RSS
    shravang Newbie

    How to get output of a sql query which has multiple fields with same name?

    Hello,

     

    I want to create a ThingWorx service with sql query. The sql query contains joins and it outputs data in the following fields:

     

         username | action | eventdate | action | eventdate

     

    As you see, the output has fields with same name. Hence, when I run this service, it shows only 3 unique columns i.e. username, action and eventdate.

    I need to see all fields in my output. As the datashape accepts only unique field names, how can get output of this service with all columns?

     

    Thanks,

    Shravan