topic Re: How to Get Row Number When There is Missing Data in Discussions

How to Get Row Number When There is Missing Data

bzanos — Fri, 09 Jun 2023 23:38:54 GMT

There is missing value in my data.

I'm trying to create script for new column 'Row Number' to get row number of lagged value of Col1(non-missing data).

I'm facing problem when missing data is encountered.

Below is my data with required row number outcome.

How to create script for this?

XanGregg — Fri, 25 Sep 2020 00:18:14 GMT

I think this will do what you're looking for. Lag() without an argument will give the lag of the current column.

New Column( "r",
	Formula(
		If(
			Row() == 1, .,
			Is Missing( Lag( :Col1 ) ), Lag(),
			Row() - 1
		)
	)
)

bzanos — Fri, 25 Sep 2020 12:18:45 GMT

It works.

Thank you.