Jump to content


Photo

How to break table output by column

table

  • Please log in to reply
4 replies to this topic

#1 autumnlin

autumnlin

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 13 March 2019 - 07:43 PM

I'm using WinNonlin 8.0 and I have a lot of timepoints in the table. My table become very wide and will not fit in one page. How can I break the table by column so that they fit in?



#2 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,115 posts

Posted 13 March 2019 - 08:55 PM

Hi Lin,
    As you probably worked out, you can force a page break by Row Stratification, but not by column stratification.

   If your data won't fit in a single page width, even in landscape; then for now I would suggest that you manually use a Filter (within Data Wizard) to split up your data into sets small enough to fit on a page.  If you have difficulty doing this, please post an example of the dataset or better yet project and we'll try to help demonstrate.
 

   If this is a data table you have ot create a lott that is ofte too wide then you could look at programming a custom table in Phoenix , alternatively there are some other modules/tools available with additional licenses like AutoPilot that have more sophiticated table formatting options, including optimising column breaks.

  Simon.


  • autumnlin likes this

#3 Ana Henry

Ana Henry

    Advanced Member

  • Members
  • PipPipPip
  • 220 posts

Posted 14 March 2019 - 02:11 PM

I'm using WinNonlin 8.0 and I have a lot of timepoints in the table. My table become very wide and will not fit in one page. How can I break the table by column so that they fit in?

Hi Lin,

As Simon mentioned there are no tricks to automatically break the table in the native WinNonlin.  Maybe you want to consider pivoting the table first so the time points are in rows and subjects are in columns but this will create a different type of table.

 

Best,

Ana



#4 Clive Rich

Clive Rich

    Newbie

  • Members
  • Pip
  • 3 posts
  • LocationUK

Posted 15 March 2019 - 11:54 AM

Hi Lin 
I'm an experienced AutoPilot user.  As Simon says, AutoPilot will do what you want whereas native PHX tables will not.  In AP, tables are split automatically by column or row where a table exceeds the dimensions you define, no matter how big your table - it uses Excel rather than PHX to create the tables. it also has other very useful functions, so if you need to do this routinely, or if you create a lot of data tables and listings it may be worth getting a demo.
 
Regards
Clive

  • autumnlin likes this

#5 autumnlin

autumnlin

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 15 March 2019 - 03:22 PM

Thank you all very much, your responses are very helpful.







Also tagged with one or more of these keywords: table

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users