3229_it-IT

liliconcom

conversione di dati numerici in caratteriHo dovuto importare diverse colonne di tipi di dati in jmp come numeriche (codice 1-4, ad esempio). Mi piacerebbe convertire i numeri in personaggi più significativi. Ad esempio in una colonna con l'etichetta "SITO", vorrei apportare la seguente modifica:

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

Questo dovrebbe essere fatto nell'editor di formule con una serie di istruzioni IF, o c'è un modo più pulito. Se uso le istruzioni IF, come posso cancellare le colonne originali numerate in codice. Grazie in anticipo.Ri: conversione di dati numerici in caratteriChe ne dici di colonna, ricodifica (l'opzione di menu, non una formula). Questo può scambiare i valori sul posto, in un'altra colonna o in una formula.Ri: conversione di dati numerici in caratteri
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
style = "font-family: Arial;"> Penso che la funzione "match"
funzionerebbe meglio  Basta creare una nuova colonna chiamata SITO e
usa la seguente formula (sostituendo: Colonna 1 con il tuo riferimento
colonna).

Corrispondenza (: colonna 1,

style = "font-family: Arial;">

1, "DL",


2, "SL",


3, "KA",


4, "MP"

);

style = "font-family: Arial;">


Se vuoi renderlo uno script, fai questo:



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 "; color: rgb (0, 0, 221);"> current
tabella dati
style = "font-size: 10pt; font-family:" Courier New "; colore: black;"> ()
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 "; colore: 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 "; colore: rgb (0, 0, 221);"> Nuovo
Colonna
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 "; color: navy;">,
style = "font-size: 10pt; font-family:" Courier New "; color: black;">



style = "font-size: 10pt; font-family:" Courier New "; color: black;">
style = "">
Personaggio
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;">
style = "">
Nominale
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;">
style = "">
Formula (

style = "font-size: 10pt; font-family:" Courier New "; color: 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 "; color: navy;">:
style = "font-size: 10pt; font-family:" Courier New "; colour: black;"> Column
1
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;">
style = "">

style = "font-size: 10pt; font-family:" Courier New "; color: teal;"> 1
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: purple;"> "DL"
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;">
style = "">

style = "font-size: 10pt; font-family:" Courier New "; color: teal;"> 2
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: purple;"> "SL"
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;">
style = "">

style = "font-size: 10pt; font-family:" Courier New "; color: teal;"> 3
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: purple;"> "KA"
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;">
style = "">

style = "font-size: 10pt; font-family:" Courier New "; color: teal;"> 4
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 "; colore: purple;"> "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 "; color: black;">)
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 "; colore: black;"> site_col

style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> <<
style = "font-size: 10pt; font-family:" Courier New "; color: black;">
Elimina la formula
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 "; colore: 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 "; colore: black;">
elimina colonne (
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: navy;">:
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; colore: black;"> Column
1 )
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: navy;">;