topic How to Code a new column by referencing text in second column? in Discussions

How to Code a new column by referencing text in second column?

Mcc99 — Wed, 24 Apr 2024 15:00:41 GMT

How would I code a new column to fill each cell with a specific text based on the text in a second column? I have a "well" column with A1-A100. I need to create a second column with Treatment "A", for wells A1-A10, "B" for wells A11-A20, etc.

Thanks!

Re: How to Code a new column by referencing text in second column?

jthi — Wed, 24 Apr 2024 15:13:28 GMT

You could use Recode platform

https://www.jmp.com/support/help/en/18.0/#page/jmp/recode-data-in-a-column.shtml

Re: How to Code a new column by referencing text in second column?

Mcc99 — Wed, 24 Apr 2024 15:17:55 GMT

Is there a way to do it by chunks/groups in the recode platform though? Doing it by hand for 100+ samples and multiple datasets would take quite a bit of time.

Re: How to Code a new column by referencing text in second column?

jthi — Wed, 24 Apr 2024 15:21:36 GMT

Have you tried it? Recode platform will provide you with a script, such as

ocal({dt, col1},
	dt = Data Table("Untitled");
	dt << Begin Data Update;
	col1 = dt << New Column(dt:Column 1);
	col1 << Set Name("Column 1 2");
	dt << Move Selected Columns({col1}, after(dt:Column 1));
	For Each Row(
		dt,
		col1[] = Map Value(
			dt:Column 1,
			{"A10", "A1", "A2", "A1", "A3", "A1"},
			Unmatched(dt:Column 1)
		)
	);
	dt << End Data Update;
);

You can then modify that as needed and maybe use something like Workflow builder to make it work with different tables. Or you can script it (Get Data Table List() and For Each are good starting points for this).