topic Re: Enhanced Log - n added after "column name" in Discussions

Enhanced Log - n added after "column name"

terapin — Fri, 09 Jun 2023 18:02:15 GMT

Folks,

In utilizing the Enhanced log with data tables that have long, descriptive column names, the output is placing a "n" after the variable name as shown in some examples below. Normally, the "n" isn't produced when the column name is short and doesn't include non-alphabetical characters such as & or ,. While the Enhanced Log code will run with these additional characters, I'd like to better understand why the "n" is produced and whether I should keep them as part of my code or remove them?

// Select where
Data Table( "PESD Stationary, Envidas SQL Data Table, 1-Min" ) <<
Select where( :"Ambient NOx, N500 Status"n == 31 );


// Subset data table
Data Table( "PESD Stationary, Envidas SQL Data Table, 1-Min" ) << Subset(
	Selected Rows( 1 ),
	columns(
		:"Date & Time"n, :Date, :Day of Year, :"Ambient NO, N500 (ppb)"n,
		:"Ambient NO, N500 Status"n, :"Ambient NO2, N500 (ppb)"n,
		:"Ambient NO2, N500 Status"n, :"Ambient NOx, N500 (ppb)"n,
		:"Ambient NOx, N500 Status"n
	)
);

Re: Enhanced Log - n added after "column name"

txnelson — Tue, 12 Oct 2021 18:35:04 GMT

The "xxxxxxx"n version of the column name is produced when JMP determines that if the actual column name will not parse correctly in open code. The easiest way to demonstrate this, is with the following example.

If a variable is named "X-Y" and one wants to create a new variable using that column, and with it, add it to the variable Z, the JSL would be

newVar = X - Y + Z;

JMP would be looking for a variable named X, a variable named Y and a variable named Z. Basically, JMP would get confused.

newVar = "X - Y"n + Z;

clarifies the situation.

Re: Enhanced Log - n added after "column name"

terapin — Tue, 12 Oct 2021 23:08:23 GMT

Not sure I completely understand given that I'm scoping my column names such as :"Column Name, Column Units". With the column scoping ( : ) I would think JMP wouldn't get confused whether I was working with a variable vs a column name.

Re: Enhanced Log - n added after "column name"

txnelson — Tue, 12 Oct 2021 23:51:55 GMT

JMP does not know how you are going to use the column names. So it is playing it safe, in that when it comes across a column name that "could" be confusing, it converts to the :xxxxxxx"n format. And in turn, it is wise for you to use it when you see that it might be confusing, even if is some cases, you might get away without a problem.

Re: Enhanced Log - n added after "column name"

jthi — Wed, 13 Oct 2021 04:46:51 GMT

In addition to txnelson's explanation, here is one link related to "col name"n syntax as you might see Name() syntax in older scripts Deprecating the Name() parser directive in JMP 16 and JMP Help - Scripting Guide - Names

Re: Enhanced Log - n added after "column name"

terapin — Wed, 13 Oct 2021 15:26:23 GMT

Thanks txnelson and jthi for your input,

Ironically, after reading txnelson's latest reply and digging around some more on the Discussion board, I stumbled on the following link in which jthi described the deprecation of the Name() parser (https://community.jmp.com/t5/Discussions/Using-new-Name-nomenclature-with-variable/m-p/365431). Sorry to have missed that subtle adjustment in the switch from version 15 to 16. Thanks folks for helping resolve this.

Re: Enhanced Log - n added after "column name"

lazzybug — Fri, 28 Apr 2023 22:23:06 GMT

@txnelson @jthi could you please help me convert the list below into another list? I cannot replace " with \!" code easily. I was stuck here, thank you so much for your help.

factors = {"Kilometer (kg)"n, "Temperature (ºC)"n};

factors = {\!"Kilometer (kg)\!"n, \!"Temperature (ºC)\!"n};

The reason to convert the list because once I pick the items from factors and tried to combine with other string, the " and n disappeared, which caused trouble for my code. If I can have the second list, it won't have any problems.

for example:

factors = {"Kilometer (kg)"n, "Temperature (ºC)"n}; responses_sim = ""; values = {1.23,2.34}; for (i=1, i<=N Items(factors), i++, responses_sim = responses_sim || factors[i] || "<< Add Random Noise(" || char(values[i]) || ")," ); show(responses_sim); responses_sim = "Kilometer (kg)<< Add Random Noise(1.23),Temperature (ºC)<< Add Random Noise(2.34),"; I want to get this result below, how to do it? responses_sim = "Kilometer (kg)"n << Add Random Noise(1.23), "Temperature (ºC)"n << Add Random Noise(2.34),"

Re: Enhanced Log - n added after "column name"

jthi — Sat, 29 Apr 2023 08:39:13 GMT

I would most likely try to build this without using strings (depending what you are doing), but:

Names Default To Here(1);

factors = {"Kilometer (kg)"n, "Temperature (ºC)"n};
responses_sim = "";
values = {1.23,2.34};

for (i=1, i<=N Items(factors), i++,
	responses_sim = responses_sim || Eval Insert("\[^factors[i]^ << Add Random Noise(^values[i]^),]\");
);
responses_sim ||= "\!"";

write(responses_sim);
//show(responses_sim);
//responses_sim = "Kilometer (kg)"n << Add Random Noise(1.23), "Temperature (ºC)"n << Add Random Noise(2.34),"

Re: Enhanced Log - n added after "column name"

lazzybug — Mon, 01 May 2023 16:05:47 GMT

@jthi Thank you so much for your help. I will use this script to simulate responses automatically