3 Replies Latest reply on Jan 16, 2018 9:01 AM by shravang RSS
    shravang Newbie

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



    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?