How to repeat values in a column when they are strings

user8421 — Sat, 10 Jun 2023 23:28:11 GMT

Hi everyone!

I've used this script below for numerical values

If( Is Missing( :Name( "For Calc - Data1" ) ),
	Lag( :Name( "Data1" ), 1 ),
	:Name( "For Calc - Data1" )
)

With the resulting table looking like this

For Calc - Data1	Data1
12	12
	12
	12
33	33
	33

However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error saying that the value must be Numeric.

For Calc - Data2	Data2
A	A
	A
	A
B	B
	B

Is there a workaround or an alternative formula I can use to achieve this?

Re: How to repeat values in a column when they are strings

txnelson — Fri, 02 Apr 2021 20:49:26 GMT

Here is the method I use

If( Row() == 1,
	x = :"For Calc - Data2"n
);
If( As Column( "For Calc - Data2" ) != "",
	x = :"For Calc - Data2"n
);
x;

topic How to repeat values in a column when they are strings in Discussions

How to repeat values in a column when they are strings

Re: How to repeat values in a column when they are strings