nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JSL Compare value in row to the next row.

ileshem

Hello,

I am trying to use "FOR" and "IF" to create a condition column.

I have this table and I want the "Con" column to indicate if the age in the row after is lower then the current row. if yes "1" if not "0"

Name	Age	Con
David	23	0
Bari	26	1
James	12	0
Lora	14	0

This is what I have: (doesn't work)

dt<< New Column( "Con", Formula( For( i = 1,i <= N Row( dt ), i++, If(:Age[i] >= :Age[i+1] , "0", "1", ))));

Your help will be appreciated.

Accepted answers

jthi

Here is two ways to do this (Row() and Lag():

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(4),
	Compress File When Saved(1),
	New Column("Name", Character, "Nominal", Set Values({"David", "Bari", "James", "Lora"})),
	New Column("Age", Numeric, "Continuous", Format("Best", 12), Set Values([23, 26, 12, 14])),
	New Column("Con", Numeric, "Continuous", Format("Best", 12), Set Values([0, 1, 0, 0]))
);

dt << New Column("Younger than Next_Row", Character, "Nominal", 
Formula(If(:Age > :Age[Row() + 1], "Yes", "No")));


dt << New Column("Younger than Next_Lag", Character, "Nominal", 
	Formula(If(:Age > Lag(:Age, -1), "Yes", "No"))
);

All comments

ian_jmp

Is this what you are after?

New Table( "Ages",
	Add Rows( 4 ),
	New Column( "Age",
		Numeric,
		"Ordinal",
		Format( "Best", 12 ),
		Set Values( [23, 26, 12, 14] )
	),
	New Column( "Younger than Previous",
		Numeric,
		"Nominal",
		Format( "Best", 12 ),
		Formula( If( :Age < Lag( :Age, 1 ), 1, 0 ) ),
		Value Labels( {0 = "No", 1 = "Yes"} ),
		Use Value Labels( 1 ),
		Set Display Width( 125 )
	)
)

ileshem

Thanks, this could work but it will mark as "Yes" the row 3 (James) and i am trying to mark row 2 (Bari) with a "Yes"
Any other solution?

jthi

Here is two ways to do this (Row() and Lag():

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(4),
	Compress File When Saved(1),
	New Column("Name", Character, "Nominal", Set Values({"David", "Bari", "James", "Lora"})),
	New Column("Age", Numeric, "Continuous", Format("Best", 12), Set Values([23, 26, 12, 14])),
	New Column("Con", Numeric, "Continuous", Format("Best", 12), Set Values([0, 1, 0, 0]))
);

dt << New Column("Younger than Next_Row", Character, "Nominal", 
Formula(If(:Age > :Age[Row() + 1], "Yes", "No")));


dt << New Column("Younger than Next_Lag", Character, "Nominal", 
	Formula(If(:Age > Lag(:Age, -1), "Yes", "No"))
);