topic Re: Create a column with a specific data pattern in Discussions

Create a column with a specific data pattern

SpannerHead — Thu, 27 Mar 2025 20:25:01 GMT

I want to add a column to my data that changes from "1" values to "-1" values every 101 rows. I saw lots of ways to get close but no solution yet. Help appreciated.

Re: Create a column with a specific data pattern

jthi — Thu, 27 Mar 2025 20:32:45 GMT

So you wish to have repeating pattern of 1, 0.98, 0.96,... -0.96, -0.98, -1?

Re: Create a column with a specific data pattern

jthi — Thu, 27 Mar 2025 20:36:45 GMT

Or first 100 rows of 1 and then 100 rows of -1?

Re: Create a column with a specific data pattern

SpannerHead — Thu, 27 Mar 2025 21:22:52 GMT

Jarmo

Second one exactly.

Re: Create a column with a specific data pattern

jthi — Thu, 27 Mar 2025 21:27:56 GMT

You can do this with different combinations of Row(), Mod(), Floor(), Ceiling()... Here is one example which might do what you are looking for

1 - 2 * Mod(Floor((Row() -1) / 100), 2)

Re: Create a column with a specific data pattern

shampton82 — Fri, 28 Mar 2025 01:37:44 GMT

Hey @SpannerHead ,

These are always fun challenges since there are so many options!

Here another way besides @jthi excellent method

If( Row() < 101,
	1,
	Lag( :Column 1, 100 ) * -1
)