379673_en-US

liliconcom

Make a combined data table from text exlporer

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

 

Data TableScriptingRe: Make a combined data table from text exlporer

Thank you, it's working !

Have a good day !

 

Margaux

Re: Make a combined data table from text exlporer

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;