topic Re: How to fill missing dates within column in Discussions

How to fill missing dates within column

chandankishor66 — Fri, 09 Jun 2023 15:59:46 GMT

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,

Re: How to fill missing dates within column

txnelson — Thu, 06 Oct 2022 05:18:59 GMT

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