topic Re: Copying Row values to other Column in Discussions

Copying Row values to other Column

JeffO — Sat, 10 Jun 2023 23:37:35 GMT

Hello,

Kindly help me I'm stuck when putting a formula into other column.

Here is expected output if SerialNumber is not empty copy row to Column ChipID else copy the same SN.

dtraw << New Column("ChipID", Character, Formula(
For( i = 1, i <= N Rows(dtraw), i++,
	If( Is Missing( :SerialNumber),
		:ChipID[i] = (:SerialNumber[1] & i = 1),
		:SerialNumber
		)
	)
);

Re: Copying Row values to other Column

jthi — Mon, 27 Sep 2021 08:28:02 GMT

You can use Lag() function here.

Names Default To Here(1);

dt = New Table("Untitled 6",
	Add Rows(6),
	New Column("SerialNumber", Character, "Nominal", Set Values({"30_A0_0", "", "", "30_A0_01", "", ""}))
);
dt << New Column("ChipID", Character, Nominal, Formula(If(Is Missing(:SerialNumber), Lag(:ChipID), :SerialNumber)));

Re: Copying Row values to other Column

txnelson — Mon, 27 Sep 2021 08:56:43 GMT

Here is my way of handling the issue

dtraw << New Column( "ChipID",
	Character,
	Formula(
		If( :SerialNumber != "",
			hold = :SerialNumber
		);
		hold;
	)
);