topic Column Information in Discussions

Column Information

SamruddhiB — Tue, 09 May 2017 10:52:36 GMT

How to get column information for all columns in a table together at one place. Need to get column information for 8 tables with 250+ columns each.

Re: Column Information

ian_jmp — Tue, 09 May 2017 11:22:22 GMT

I suppose it depends on what you consider informative, and how, exactly, you want this information displayed.

But if you want everything about a columns in a table, apart from the data they contain, you ciuld make a copy of the table, delete all the rows, then do 'Copy Table Script' from the triangle menu of the table. Then paste the results into a new script window to inspect the result. For eight tables, you could do this with JSL, and also post-process, reformat and display the results how you want.

Re: Column Information

Jeff_Perkinson — Tue, 09 May 2017 12:01:43 GMT

We could use some more details about what column information your looking for and how you'll use it but perhaps another option is Cols -> Columns Viewer.

Re: Column Information

SamruddhiB — Wed, 17 May 2017 07:21:48 GMT

Thank you for this solution!

Is there a way in the columns viewer to get the column attributes like 'Data Type' and 'Modeling Type'?

Re: Column Information

ian_jmp — Wed, 17 May 2017 09:36:14 GMT

If you want this information you could get it this way:

NamesDefaultToHere(1);

// Define a function: Given a table reference, makes a window with the required information
dataAndModelingType = 
Function({dat}, {Default Local},
	cols = dt << getColumnNames("String");
	na = {};
	dt = {};
	mt = {};
	for(c=1, c<=NItems(cols), c++,
		InsertInto(na, Column(dat, cols[c]) << getName);
		InsertInto(dt, Column(dat, cols[c]) << getDataType);
		InsertInto(mt, Column(dat, cols[c]) << getModelingType);
	);
	NewWindow("Data and Modeling Types in "||(dat << getName),
		PanelBox("Column Info",
			TableBox(
				StringColBox("Column Name", na),
				StringColBox("Data Type", dt),
				StringColBox("Modeling Type", mt)
				);
			);
		);
	);

// Try it out
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
dataAndModelingType(dt);

This could probably be appended to the 'Column Info' dialog but would be more work.

So, as I said, the answer does depend on what information you want, how you want it displayed and (possibly) what you want to use it for next.

Re: Column Information

Justin_Chilton — Mon, 05 Jun 2017 21:27:12 GMT

I published a JMP add-in earlier today that does what you are looking for. Check it out here.

Re: Column Information

SamruddhiB — Tue, 06 Jun 2017 06:25:14 GMT

Tons of thank you for this solution!

Just wondering if we change the attribute table and save it, then can we apply the changes directly to the data table in JMP itself?

Re: Column Information

Justin_Chilton — Tue, 06 Jun 2017 17:06:01 GMT

I do have plans to add a feature like that at some point in the future. I will let you know when it is updated.

Re: Column Information

powerpuff — Fri, 09 Mar 2018 21:46:03 GMT

Hi @ian_jmp I am trying to tweek your script to also extract "Coding" from Column Information and it doesn't seem to work. Is it possible to also extract the "Coding" section? Thanks

Re: Column Information

Jeff_Perkinson — Fri, 09 Mar 2018 22:56:47 GMT

The Get Property message to the data table column will get you the Coding property.

Look at the complete list of messages for data table column in the Help->Scripting Index.