How to fill missing dates within column

[#1]

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,

[#2 · Accepted solution]

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;
);