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; } } }

Find a column whose name needs a string from another column

UnivariateTable

I am trying to use a value from a column named "Freq " and find another column . I get an error Invalid Row

The column I am looking for is available. The column Freq is numeric. Is that the issue?

For example the value in a row of the column Freq is 200 then I am looking for the value in IDynatTsense__200__65 .

Code:

HashFreqval = Column( "Freq" );

IDyn = Column( "IDynatTsense__"||HashFreqval[]|| "__65" );

Error:

Accepted answers

jthi

If your data is much more complicated and you don't need a formula, I would most likely just use For Each Row

Names Default To Here(1);

dt = Open("$DOWNLOADS/TestDataJunk.jmp");

dt << New Column("NewVal2", Numeric, Continuous);

For Each Row(dt,
	val = Column(dt, "HashFreq")[Row()];
	val_col = Eval Insert("Idyn_^val^_65");
	Column(dt, "NewVal2")[Row()] = Column(dt, val_col)[Row()];
);

All comments

hogi

column[] returns the value of the current row().

The default value of row() is 0. To access the value of row 1, just adjust the pointer via row()=1;

New Table( "test",
	Add Rows( 1 ),
	New Column( "Freq",
	Character,
		Set Values( {"200"} )
	),
	New Column( "IDynatTsense__200__65",
		Set Values( [20] )
	)
);


HashFreqval = Column( "Freq" );
row()=1;
IDyn = Column( "IDynatTsense__"||HashFreqval[]|| "__65" );

jthi

Error is caused by what hogi wrote, column()[] (same as column()[row()]) is looking for a value of current row which by default is 0 in JMP, which is invalid row number (you can read about this from Iterate on Rows in a Table (jmp.com)).

How are you utilizing this code? Most likely this isn't the whole code you are using? You are looking value from "Freq" but which row and are you maybe looping them? Are you trying to get a value from IDynatTsense__200__65 (which row?) or just the reference?

UnivariateTable

Maybe my question is not very clear. I am attaching a simple example

Depending on the value in the column HashFreq, I need to select data from either column Idyn_200_65 or Idyn_400_65.

Once I can get that data , I can use a formula to calculate further.

Names Default To Here( 1 );
dt1 = Open( "TestDataJunk.jmp" );
HashFreqval = Column( "HashFreq" );
IDyn = Column( "IDynatTsense__"||HashFreqval[]|| "__65" );
dt1 << New Column( "NewVal", Numeric, Continuous, Formula( IDyn[] ));

Thanks for your help!

TestDataJunk.jmp

jthi

If your data is much more complicated and you don't need a formula, I would most likely just use For Each Row

Names Default To Here(1);

dt = Open("$DOWNLOADS/TestDataJunk.jmp");

dt << New Column("NewVal2", Numeric, Continuous);

For Each Row(dt,
	val = Column(dt, "HashFreq")[Row()];
	val_col = Eval Insert("Idyn_^val^_65");
	Column(dt, "NewVal2")[Row()] = Column(dt, val_col)[Row()];
);