topic Re: Concatenate from subset data table in Discussions

Concatenate from subset data table

UserID16644 — Sat, 10 Jun 2023 23:40:03 GMT

Hi all,

I am trying to concatenate data (dt1) from my subset tables (e.g subset by gender)

dt1 also has a column name gender. However, when I try to concatenate the subset data into dt1, it kept on creating another column (gender, gender1, gender2) where the data from the subset tables are placed and not on the gender column on dt1.

How can I concatenate data from subset tables to the specified column?

Re: Concatenate from subset data table

markschwab — Fri, 05 Nov 2021 03:00:42 GMT

Is Tables -> Update -> Match Columns able to achieve what you're trying to do?

Re: Concatenate from subset data table

UserID16644 — Fri, 05 Nov 2021 09:51:48 GMT

Nope. Im trying to concatenate data from my subset table

Re: Concatenate from subset data table

ron_horne — Fri, 05 Nov 2021 11:42:12 GMT

Hi @UserID16644

try the followoing script see if it behaves well

// Open Data Table: Big Class.jmp
Open( "$SAMPLE_DATA/Big Class.jmp" );

// Select matching cells
Data Table( "Big Class" ) << Select Where( :sex == "F" );

// Subset data table
// → Data Table( "Subset of Big Class" )
Data Table( "Big Class" ) << Select Where( :sex == "F" ) <<
Subset( Selected Rows( 1 ), Selected columns only( 0 ) );


// Concatenate tables
Data Table( "Big Class" ) << Concatenate(
	Data Table( "Subset of Big Class" ),
	Append to first table
);

if it is well behaved try to understand what are the differences from the other results.

the only time i get new columns created using concatenate is when column names do not match.

let us know if it works.

ron