553237_en-US

liliconcom

How to fill missing dates within column

Hi JMP users,

I have a table which contains two columns.

1. Time

2. Date.

Time column has continuous entries but Date column has only few entries and that entries denote samples loading time/date.

How to completly fill the date coulm for each day. Screnshoot attached below

 

  

Regards,

 

ScriptingRe: How to fill missing dates within column

Interactively, you can right click on a filled date cell and select "fill", and then you can choose to fill to the end of the table, or fill to a specified row.

Or you can run this little script and it will do the job for you

Names Default To Here( 1 );
dt = Current Data Table();

For Each Row(
 If( Is Missing( :date ) == 0,
  currDate = :date
 );
 :date = currDate;
);