topic Re: how to put a list into a table cell under a column in Discussions

how to put a list into a table cell under a column

dadawasozo — Thu, 08 Jun 2023 16:33:34 GMT

Hi,

I created variables that are list. I want to create new column that under if statement will fill up the cell with those variables. So I can get table as below. How can I add list into a cell?

A={"96", "104", "112", "120"};
B={"1", "100", "111", "121"};
C={"6", "14", "112", "129"};
D={"9", "124", "132", "160"};

dt << New column("Value", Expression, formula(
	
	if (
		:Mode=="A" , A,
		:Mode=="B" , B,
		:Mode=="C" , C,
		:Mode=="D" , D,
		
		
	)

Re: how to put a list into a table cell under a column

txnelson — Fri, 24 Feb 2023 04:47:34 GMT

Your code works fine for me

Names Default To Here( 1 );
dt = Current Data Table();

A = {"96", "104", "112", "120"};
B = {"1", "100", "111", "121"};
C = {"6", "14", "112", "129"};
D = {"9", "124", "132", "160"};

dt << New Column( "Value",
	Expression,
	formula(
	
		If(
			:Mode == "A", A,
			:Mode == "B", B,
			:Mode == "C", C,
			:Mode == "D", D
		)
	)
);

Re: how to put a list into a table cell under a column

jthi — Fri, 24 Feb 2023 05:58:31 GMT

Besides missing few closing brackets and having extra , I don't see issues with the script as @txnelson also said

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(5),
	Compress File When Saved(1),
	Set Header Height(46),
	New Column("Mode", Character, "Nominal", Set Values({"A", "C", "A", "A", "D"}))
);

A = {"96", "104", "112", "120"};
B = {"1", "100", "111", "121"};
C = {"6", "14", "112", "129"};
D = {"9", "124", "132", "160"};

dt << New Column("Value",
	Expression,
	formula(
	
		If(
			:Mode == "A", A,
			:Mode == "B", B,
			:Mode == "C", C,
			:Mode == "D", D
		)
	)
);

If you need to have a formula and not values in those cells, I would suggest checking out as it will most likely prevent some issues which might occur.

Re: how to put a list into a table cell under a column

dadawasozo — Fri, 24 Feb 2023 13:20:56 GMT

Hi Jim,

Your are right. I 'm not sure what was the problem that it wasn't working previously. It works after I close JMP and reopen it.