3229_fr-FR

liliconcom

convertir des données numériques en caractèresJ'ai dû importer plusieurs colonnes de type de données dans jmp sous forme numérique (codée 1-4, par exemple). J'aimerais convertir les chiffres en caractères plus significatifs. Par exemple, dans une colonne intitulée "SITE", j'aimerais apporter le changement suivant:

1 == DL
2 == SL
3 == KA
4 == MP

Cela devrait-il être fait dans l'éditeur de formule avec une série d'énoncés IF ou existe-t-il une méthode plus propre? Si j'utilise des instructions IF, comment puis-je supprimer les colonnes d'origine codées numériquement? Merci d'avance.Re: convertir des données numériques en caractèresQue diriez-vous de la colonne, recoder (l'option de menu, pas une formule). Cela peut échanger les valeurs en place, dans une autre colonne ou dans une formule.Re: convertir des données numériques en caractères
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
style = "font-family: Arial;"> Je pense que la fonction "match"
fonctionnerait mieux.  Il suffit de créer une nouvelle colonne appelée SITE, et
utilisez la formule suivante (en remplaçant: Column 1 avec votre référence
colonne).

Match (: Colonne 1,

style = "font-family: Arial;">

1, "DL",


2, "SL",


3, "KA",


4, "MP"

)

style = "font-family: Arial;">


Si vous voulez en faire un script, procédez comme suit:



dt
style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> =
style = "font-size: 10pt; font-family:" Courier New "; color: black;">

style = "font-size: 10pt; font-family:" Courier New "; couleur: rgb (0, 0, 221);"> actuel
tableau de données
style = "font-size: 10pt; font-family:" Courier New "; couleur: noir;"> ()
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: black;">



style = "font-size: 10pt; font-family:" Courier New "; color: black;"> site_col

style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> =
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
dt
style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> <<
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; couleur: rgb (0, 0, 221);"> New
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;"> "SITE"
style = "font-size: 10pt; font-family:" Courier New "; couleur: 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 "; couleur: 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 "; couleur: marine;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">



style = "font-size: 10pt; font-family:" Courier New "; color: black;">
style = "">
Formule (

style = "font-size: 10pt; font-family:" Courier New "; couleur: rgb (0, 0, 221);"> Match
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 "; couleur: marine;">:
style = "font-size: 10pt; font-family:" Courier New "; color: black;"> Column
1
style = "font-size: 10pt; font-family:" Courier New "; couleur: 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 "; couleur: sarcelle;"> 1
style = "font-size: 10pt; font-family:" Courier New "; couleur: marine;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">

style = "font-size: 10pt; font-family:" Courier New "; couleur: violet;"> "DL"
style = "font-size: 10pt; font-family:" Courier New "; couleur: 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: teal;"> 2
style = "font-size: 10pt; font-family:" Courier New "; couleur: marine;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">

style = "font-size: 10pt; font-family:" Courier New "; couleur: violet;"> "SL"
style = "font-size: 10pt; font-family:" Courier New "; couleur: 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: teal;"> 3
style = "font-size: 10pt; font-family:" Courier New "; couleur: marine;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">

style = "font-size: 10pt; font-family:" Courier New "; couleur: violet;"> "KA"
style = "font-size: 10pt; font-family:" Courier New "; couleur: 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: teal;"> 4
style = "font-size: 10pt; font-family:" Courier New "; couleur: marine;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">

style = "font-size: 10pt; font-family:" Courier New "; couleur: violet;"> "MP"
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 "; couleur: noir;">>
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: black;">



style = "font-size: 10pt; font-family:" Courier New "; color: black;"> site_col

style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> <<
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
Supprimer la formule
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: black;">



style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; couleur: noir;"> dt

style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; couleur: marine;"> <<
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; couleur: noir;">
supprimer des colonnes (
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; couleur: marine;">:
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: black;"> Column
1 )
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; couleur: marine;">;