cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-273139%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92JSL%20Combine%20Columns()%E3%81%AB%E5%85%A5%E3%82%8C%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-273139%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%B3%AA%E5%95%8F%E3%81%AF%E3%80%81Combine%20Columns()%20%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%82%82%E3%81%AE%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3EScripting%20index%20%E3%81%8B%E3%82%89%E3%80%81%E4%BB%A5%E4%B8%8B%E3%81%AE%E4%BE%8B%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FConsumer%20Preferences.jmp%22%20)%3B%0Adt%20%26lt%3B%26lt%3B%20Combine%20Columns(%0A%20delimiter(%20%22%2C%22%20)%2C%0A%20Columns(%0A%20%20%3CFONT%20color%3D%22%23FF0000%22%3E%3ABrush%20After%20Waking%20Up%2C%0A%20%20%3ABrush%20After%20Meal%2C%0A%20%20%3ABrush%20Before%20Sleep%2C%0A%20%20%3ABrush%20Another%20Time%3C%2FFONT%3E%0A%20)%2C%0A%20Selected%20Columns%20are%20Indicator%20Columns(%201%20)%2C%0A%20Column%20Name(%20%22When%20to%20Brush%22%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E7%A7%81%E3%81%AE%E5%95%8F%E9%A1%8C%E3%81%AF%E3%80%81%E3%83%A9%E3%83%B3%E3%83%80%E3%83%A0%E3%81%AA%20100%20%E5%88%97%E3%81%8B%E3%82%89%20200%20%E5%88%97%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%81%8C%E3%81%82%E3%82%8B%E3%81%93%E3%81%A8%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92%E5%8F%96%E5%BE%97%E3%81%97%E3%80%81%E6%AD%A3%E7%A2%BA%E3%81%AA%E5%88%97%E5%90%8D%E3%82%92%E8%B5%A4%E3%81%84%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88%E3%81%A7%E7%BD%AE%E3%81%8D%E6%8F%9B%E3%81%88%E3%82%8B%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%99%E3%81%8B%3F%3C%2FP%3E%3CP%3E%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-273139%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%86%E3%82%A3%E3%83%B3%E3%82%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-273145%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92%20JSL%20Combine%20Columns()%20%E3%81%AB%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-273145%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BB%A5%E4%B8%8B%E3%81%AE%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E5%8F%82%E7%85%A7%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%9D%E3%82%8C%E3%81%AF%E5%AE%9F%E9%9A%9B%E3%81%AB%E3%81%AF%E7%B0%A1%E5%8D%98%E3%81%AA%E3%82%82%E3%81%AE%E3%81%A7%E3%80%81%E3%81%A1%E3%82%87%E3%81%A3%E3%81%A8%E7%AB%8B%E3%81%A1%E5%BE%80%E7%94%9F%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A0%E3%81%91%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%8C%E3%82%93%E3%81%B0%E3%81%A3%E3%81%A6%E3%80%81%E5%AD%A6%E3%81%B3%E7%B6%9A%E3%81%91%E3%81%A6..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20current%20data%20table()%3B%0AN%20%3D%20Ncol()%3B%0Adt%20%26lt%3B%26lt%3B%20Combine%20Columns(%0A%20delimiter(%20%22%2C%22%20)%2C%0A%20Columns(%0A%201%3A%3AN%20%20%0A%20)%2C%0A%20Selected%20Columns%20are%20Indicator%20Columns(%200%20)%2C%0A%20Column%20Name(%20%22Combined%22%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-273141%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92%20JSL%20Combine%20Columns()%20%E3%81%AB%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-273141%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJSL%20%E5%BD%A2%E5%BC%8F%E3%81%AE%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%AB%E8%B5%A4%E3%81%84%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88%E3%81%8C%E3%81%AA%E3%81%84%E3%81%AE%E3%81%AF%E6%AE%8B%E5%BF%B5%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E8%B5%A4%E3%81%84%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88%E3%81%AE%E5%88%97%E3%81%AE%E5%90%8D%E5%89%8D%E3%81%AE%E4%B8%8B%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3E%EF%BC%9A%E8%B5%B7%E5%BA%8A%E5%BE%8C%E3%81%AE%E3%83%96%E3%83%A9%E3%83%83%E3%82%B7%E3%83%B3%E3%82%B0%E3%80%81%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23FF0000%22%3E%20%EF%BC%9A%E9%A3%9F%E5%BE%8C%E3%81%AE%E3%83%96%E3%83%A9%E3%83%83%E3%82%B7%E3%83%B3%E3%82%B0%E3%80%81%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23FF0000%22%3E%20%EF%BC%9A%E5%B0%B1%E5%AF%9D%E5%89%8D%E3%81%AE%E3%83%96%E3%83%A9%E3%83%83%E3%82%B7%E3%83%B3%E3%82%B0%E3%80%81%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23FF0000%22%3E%20%3A%E3%83%96%E3%83%A9%E3%83%83%E3%82%B7%E3%83%B3%E3%82%B0%E3%83%BB%E3%82%A2%E3%83%8A%E3%82%B6%E3%83%BC%E3%83%BB%E3%82%BF%E3%82%A4%E3%83%A0%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
steven_gong
Level II

How to get all columns into JSL Combine Columns()?

The question is about Combine Columns().

From Scripting index, I can find below example.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
dt << Combine Columns(
	delimiter( "," ),
	Columns(
		:Brush After Waking Up,
		:Brush After Meal,
		:Brush Before Sleep,
		:Brush Another Time
	),
	Selected Columns are Indicator Columns( 1 ),
	Column Name( "When to Brush" )
);

My problem is that I have random 100 columns to 200 columns of data.

How can I utilize the script to get all columns to replace above exact column name in red font?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
steven_gong
Level II

Re: How to get all columns into JSL Combine Columns()?

I tried that out, see below script.

It's actually an easy one, just stuck there for a moment.

Keep trying, keep learning..

 

dt = current data table();
N = Ncol();
dt << Combine Columns(
	delimiter( "," ),
	Columns(
	1::N		
	),
	Selected Columns are Indicator Columns( 0 ),
	Column Name( "Combined" )
);

View solution in original post

2 REPLIES 2
steven_gong
Level II

Re: How to get all columns into JSL Combine Columns()?

Sorry for that there is no red fond in the JSL formatted script.

It's about below column's name in red font.

:Brush After Waking Up,
:Brush After Meal,
:Brush Before Sleep,
:Brush Another Time

steven_gong
Level II

Re: How to get all columns into JSL Combine Columns()?

I tried that out, see below script.

It's actually an easy one, just stuck there for a moment.

Keep trying, keep learning..

 

dt = current data table();
N = Ncol();
dt << Combine Columns(
	delimiter( "," ),
	Columns(
	1::N		
	),
	Selected Columns are Indicator Columns( 0 ),
	Column Name( "Combined" )
);

Recommended Articles