@ Ribs11380
Pourriez-vous poster une maquette de ce que vous avez et de ce que vous voulez ?
Lors de la concaténation de colonnes, les entrées et les sorties sont de type caractère.Si vous encapsulez votre concaténation dans num (votre formule concat ici), dans l'éditeur de formule, si les données résultantes peuvent être converties en nombre, elles le seront.Si vous forcez un type de caractère à devenir un nombre via les propriétés de colonne, il sera effacé car les types de caractères ne sont pas des nombres.
@StarfruitBob souligne que la fonction num(...) convertira les données de caractères en numériques. Il existe également une fonction char(...) qui convertit les données numériques en caractères.
Vous pouvez utiliser une colonne de formules pour la concaténation de deux colonnes numériques. La formule de la colonne de formules peut être
char(a) || char(b)
pour les colonnes numériques a et b. Vous souhaiterez probablement conserver les données numériques dans des colonnes numériques pour un travail ultérieur. Le convertir en personnage entraînera des plates-formes comme ajuster y par x produire le mauvais rapport pour les données numériques.
Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Le nom est une variable de caractère qui créera des tracés logistiques, de contingence ou à sens unique en fonction de l'axe sur lequel il est utilisé et du type de l'autre axe.
Fixer Y par X produit la bivariée attendue pour deux colonnes numériques.
Merci à vous deux d'avoir tendu la main ! J'ai joint un exemple fictif de ce que j'essaie de faire. Fondamentalement, j'ai besoin que la feuille de calcul et la date soient disponibles à la fois en numérique et en caractère afin que je puisse concaténer les deux ensemble pour obtenir le résultat souhaité: Ex: 1_24May2023, 2_25May2023, etc. Sous la feuille de calcul Concat et la colonne de date. Je suis d'accord pour avoir des colonnes supplémentaires avec les mêmes données également, par exemple avoir une feuille de calcul de caractères ayant une nouvelle colonne créée et elle peut être étiquetée Feuille de calcul numérique et vice versa avec Date numérique avec la création d'une nouvelle colonne intitulée Date de caractère. Cela semble si simple, mais je suis capable de faire quelque chose d'aussi simple que d'insérer une nouvelle colonne, puis de coller la colonne dans une nouvelle colonne et de la renommer.
Vous pouvez concaténer votre colonne de feuille de calcul de caractères avec votre colonne de date numérique en utilisant la formule suivante
:Character Worksheet || "_" || Format(
:Numeric Date,
"ddMonyyyy",
9
)
ou en utilisant la fonction Concat()
Concat( :Character Worksheet, "_",
Format( :Numeric Date, "ddMonyyyy", 9 )
);
La fonction Format() renvoie la date sous forme de chaîne de caractères
cliquez avec le bouton droit sur le haut de la nouvelle colonne, choisissez la formule dans le menu contextuel. Ajoutez la formule pour faire ce dont vous avez besoin.
the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.le || est l'opérateur de concaténation. Il existe un tas de formats de date parmi lesquels vous pouvez choisir.
Cliquez avec le bouton droit sur une colonne-> Informations sur la colonne est la façon dont je redécouvre généralement les noms de format. Je recommanderais de faire des noms qui se trient bien dans la plupart des cas ; mettre probablement l'année en premier, puis le mois, le jour et le numéro de feuille en dernier. Sauf si vous avez besoin de toutes les feuilles 1 pour les trier ensemble.
the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.les formats datetime sont dans une catégorie distincte.
Salut tout le monde-
Je suis un utilisateur relativement nouveau de JMP 17 Pro et je travaille sur un projet dans lequel j'ai une colonne de données dont j'ai besoin à la fois comme type de données caractère ET comme type de données numérique. J'ai besoin des deux colonnes car je veux 1) concaténer deux colonnes différentes (en utilisant Character) tout en ayant les mêmes données que Numeric dans une deuxième colonne. Actuellement, si je change la colonne en caractère, je peux utiliser avec succès la fonction Concat, mais après avoir créé ceci, je vais changer la colonne en numérique, ma colonne Concat reste vide sur moi. Merci pour votre aide!
