2 Replies Latest reply: May 1, 2017 6:26 AM by Omar Pennacchio RSS

    Export/show all fields (with all values) of a table

    Omar Pennacchio

      Hi all

       

      I fetched one record from a database with several fields. Now I would like to export or show all the fields with their values in one table.

      Export to CSV/XLS is as well possible.

       

      Preview function of the "Data model viewer" is exactly what I need - but horizontal scrolling of 400 fields is not very practical....

       

      Any help highly appreciated.

        • Re: Export/show all fields (with all values) of a table
          Andy Weir

          Trying to display 40O fields in a table isn't going to look good whatever you use. 

           

          In sense as you've seen it uses horizontal scrolling.

           

          All chart objects can be exported to excel in data form. Clicking on the object should give you an export option menu with data being one of them.

           

          If you need a scheduled export of data then look at nprinting.

            • Re: Export/show all fields (with all values) of a table
              Omar Pennacchio

              Hi Andy

               

              So basically I am trying to get a very fast way to export the data so that I can see if e.g. a join was successful.

               

              Fully agree that showing 400 fields is not best practices. This is just for test purposes to show one record and choose the right fields.

              Unfortunately I cannot show the fields with their values in a table (system fields $table and so on are not showing the values of the fields).

               

              A command which just dumps out all fields of table with the 1st row of values would be nice - but not on horizontal way.

               

              Maybe I find a way to script it (a simple loop should do the job).