2935_fr-FR
Dissocier des tables dans JSLPeut-être que je suis juste lent aujourd'hui, mais je n'arrive pas à comprendre. Tout ce que je veux faire, c'est créer un tableau récapitulatif (ou une sorte de tableau lié) et fermer le tableau d'origine sans fermer le tableau lié. Des idées?
Exemple:
dt = Nouvelle Table( "bière",
Ajouter des lignes ( 4 ),
Nouvelle colonne( "Groupe",
Personnage,
Nominal,
Définir les valeurs( {"bière foncée", "bière foncée", "garbage", "garbage"} )
),
Nouvelle colonne( "Bière",
Personnage,
Nominal,
Définir les valeurs(
{"schwarzbier", "munich dunkel", "light american lager", "malt liquor"}
)
),
Définir les états de ligne ([0, 0, 1, 0])
);
bob = dt << Résumé( Groupe( :Groupe ) );
fermer(dt,pas de sauvegarde);Re : dissocier des tables dans JSLJe parie que ça marcherait ! Merci!Re : dissocier des tables dans JSLQuelque chose comme ça pourrait faire:
style="font-size: 10pt; font-family: "Courier New"; color: black;">dt
style="font-size: 10pt; font-family: "Courier New"; color: marine;">=
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Nouveau
Tableau
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"bière"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Ajouter
Lignes (
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">4
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Nouveau
Colonne
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"Groupe"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Personnage
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Nominal
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Ensemble
Valeurs (
{
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"dark
blonde"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"dark
blonde"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"garbage"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"garbage"
style="font-size: 10pt; font-family: "Courier New"; color: black;">}
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Nouveau
Colonne
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"Bière"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Personnage
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Nominal
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Ensemble
Valeurs (
{
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"schwarzbier"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"munich
dunkel"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"light
bière blonde américaine"
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"malt
alcool"
style="font-size: 10pt; font-family: "Courier New"; color: black;">}
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Ensemble
États de ligne (
[
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">0
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">0
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">1
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">0
style="font-size: 10pt; font-family: "Courier New"; color: black;">]
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: black;">)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">;
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">bob
style="font-size: 10pt; font-family: "Courier New"; color: marine;">=
style="font-size: 10pt; font-family: "Courier New"; color: black;">
dt
style="font-size: 10pt; font-family: "Courier New"; color: marine;"><<
style="font-size: 10pt; font-family: "Courier New"; color: black;">
Résumé (
Groupe (
style="font-size: 10pt; font-family: "Courier New"; color: marine;"> :
style="font-size: 10pt; font-family: "Courier New"; color: black;">Groupe
)
)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">;
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">bob
style="font-size: 10pt; font-family: "Courier New"; color: marine;"><<
style="font-size: 10pt; font-family: "Courier New"; color: black;">
Sous-ensemble (
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Sortir
Tableau (
style="font-size: 10pt; font-family: "Courier New"; color: purple;">"Bière
Résumé"
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">
Copie
formule (
style="font-size: 10pt; font-family: "Courier New"; color: sarcelle;">0
style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
style="font-size: 10pt; font-family: "Courier New"; color: black;">)
style="font-size: 10pt; font-family: "Courier New"; color: marine;">;
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: rgb(0, 0, 221);">Fermer
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">
dt
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: navy;">,
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">
pas de sauvegarde )
style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: navy;">;Re : dissocier des tables dans JSLIl semble qu'il s'agisse d'une nouvelle fonction pour JMP 9, que j'utilise la plupart du temps. J'ai quelques scripts que je partage avec les utilisateurs de JMP 8. Quelqu'un sait comment faire dans JMP 8 ?Re : dissocier des tables dans JSLPas grave. Je l'ai compris. Je cherchais "unlink" dans le Scripting Guide. La recherche de "Link" m'y a finalement conduit.
Par défaut, un tableau récapitulatif est lié au tableau de données d'origine. Si vous souhaitez produire un résumé qui n'est pas lié au tableau de données d'origine, ajoutez cette option à votre message de résumé :
summDt << Summary( Group( col ), Mean( :height ),
Lien vers la table de données d'origine ( 0 )
);