topic Re: Make a combined data table from text exlporer in Discussions

Make a combined data table from text exlporer

MargauxR — Sat, 10 Jun 2023 23:29:11 GMT

Hello everybody,

I have some trouble to create my combined data table from a script.

I try to make a script to analyse a table with word and samples.

I do manually the text explorer of word (called "Termes" in my data table) by samples (called "Num Ech" in my data table) and than i create a combined data table to have a data table with the count of each word by sample.

I found a script to do the text explorer, but i don't understand how to create the combined data table. this is my script :

dta3 = Current data table ();
dta3 << Delete Columns("MOTS");
LV = dta3 << Select Where(Is missing(:TERMES));
LV << Delete Rows;

txt = dta3 << Text Explorer(
	Text Columns( :TERMES ),
	Tokenizing( "Basic Words" ),
	Language( "French" ),
	by( :NUM ECH ),
); 
Report(txt)[Outline Box("Liste des termes et des phrases")][Table Box(1) ]<< Make combined Data Table;

Any idea ?

Thank you !

Margaux

Re: Make a combined data table from text exlporer

ms — Mon, 26 Apr 2021 21:39:35 GMT

The problem may be that you have a By( ) column that adds another layer to the report. The variable txt is then not a Text Explorer object but a list of several objects.

I don't have French JMP installed, but try the code below. The only difference is the index [1] that points to the first "sub-report".

Report( txt[1] )[Outline Box( "Liste des termes et des phrases" )][Table Box( 1 )] <<
Make Combined Data Table;

Re: Make a combined data table from text exlporer

MargauxR — Thu, 29 Apr 2021 12:37:33 GMT

Thank you, it's working !

Have a good day !

Margaux