Ho to handle cryptic Column names?

hogi

In my data table, I have thousands of cryptic column names.

Is there a possibility to facilitate work with the table (human readable names)  - but keep the data table compatible with the incoming data (keep cryptic names).

 

e.g.

- alternative column name in the preferences

- replace column names with name from notes 

- extend "search for notes"?

 

 

 

Column Manager in Jmp18 already helps a bit:

 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Data Table( "Big Class" ):height << Set Name( "FDGDGD_645643545343_h" )<< Set Property( "Notes", "height" );
Data Table( "Big Class" ):weight << Set Name( "DFGDGD_435435343_w" )<< Set Property( "Notes", "weight" );

 

jthi

You could create mapping table and use that to go back and forth with Recode

 

Columns can also have multiple names but no idea how to access those expect by changing the language (x-id seems the most interesting here)

New Column(["en" => "name", "ja" => "名前", "x-id" => "S_name_Col", "zh-CN" => "姓名"],
	Character,
	"Nominal",
	Set Property(
		"Notes",
		["en" => "...usually used as a label variable in plots",
		"ja" => "散布図のラベル変数として使用する。",
		"x-id" => "S_usually_used_as_a_label_variable_Not",
		"zh-CN" => "...通常用作图中的标签变量"]
	),
	Set Selected,
	Set Display Width(0)
)

You can also add your own, but again no idea how to access those (except from the column script)

Names Default To Here(1);

dt = New Table("");
dt << New Column(["en" => "test", "x-id" => "TEST2", "AAA" => "BBB"]);
Show(Arg(column(1) << get script));