Hey,
I would like to combine 2 columns by scripting but no so much support for that in documentation. Does anyone have an example?
Thank you,
Florence
Hi Florence,
From the scripting index:
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
dt << Text To Columns(
delimiter( "," ),
columns( :Brush Delimited )
);
Thank you Brady,
But I would like to do the opposite. If I’m right, your function segment multiple responses from a column to several columns. I would like to do the opposite. Put several columns in one column:
It seems that the function is named Combine columns but no details
De : BradyBrady
Envoyé : mercredi 24 février 2016 18:38
À : Florence Kussener <Florence.Kussener@jmp.com>
Objet : Re: - JSL - Combine Columns
JMP User Community<https://community.jmp.com/?utm_source=JIVE&utm_medium=email&utm_campaign=System Email Tracking>
JSL - Combine Columns
reply from BradyBrady<https://community.jmp.com/people/BradyBrady?et=watches.email.thread> in JMP SE Community - View the full discussion<https://community.jmp.com/message/226961?et=watches.email.thread#226961>
Hi Florence, see if this works? I'm using JMP 13, so there may be more scripting examples than in JMP 12.
dt << Combine Columns(
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" )
Yes !!
So sorry, I was so much concentrated in my scripting that I didn’t think about JMP13 documentation.
Thank a lot,
Envoyé : mercredi 24 février 2016 18:48
reply from BradyBrady<https://community.jmp.com/people/BradyBrady?et=watches.email.thread> in JMP SE Community - View the full discussion<https://community.jmp.com/message/226962?et=watches.email.thread#226962>