@Ribs11380
Könnten Sie ein Modell dessen veröffentlichen, was Sie haben und was Sie wollen?
Beim Verketten von Spalten sind die Ein- und Ausgaben ein Zeichentyp.Wenn Sie Ihre Verkettung in num einschließen (hier Ihre Verkettungsformel), können die resultierenden Daten im Formeleditor in eine Zahl umgewandelt werden.Wenn Sie über die Spalteneigenschaften erzwingen, dass ein Zeichentyp eine Zahl wird, wird er gelöscht, da Zeichentypen keine Zahlen sind.
@StarfruitBob weist darauf hin, dass die Funktion num(...) Zeichendaten in numerische Daten umwandelt. Es gibt auch eine char(...)-Funktion, die numerische Daten in Zeichen umwandelt.
Möglicherweise möchten Sie eine Formelspalte für die Verkettung zweier numerischer Spalten verwenden. Die Formel der Formelspalte könnte sein
char(a) || char(b)
für die numerischen Spalten a und b. Wahrscheinlich möchten Sie numerische Daten für die weitere Arbeit in numerischen Spalten aufbewahren. Die Konvertierung in einen Charakter führt zu Plattformen wie Passe y an x an um den falschen Bericht für numerische Daten zu erstellen.
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.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 ist eine Zeichenvariable, die abhängig von der Achse, auf der sie verwendet wird, und vom Typ der anderen Achse Logistik-, Kontingenz- oder Einwegdiagramme erstellt.
Fix Y by X erzeugt die erwartete Bivariate für zwei numerische Spalten.
Vielen Dank an euch beide, dass ihr euch gemeldet habt! Ich habe ein Scheinbeispiel für das beigefügt, was ich zu tun versuche. Grundsätzlich muss sowohl das Arbeitsblatt als auch das Datum sowohl in numerischer als auch in Zeichenform verfügbar sein, damit ich beide zusammenfügen kann, um das gewünschte Ergebnis zu erhalten: Beispiel: 1_24. Mai 2023, 2_25. Mai 2023 usw. Unter der Spalte „Arbeitsblatt und Datum verknüpfen“. Ich bin damit einverstanden, auch zusätzliche Spalten mit den gleichen Daten zu haben, also zum Beispiel, wenn im Zeichenarbeitsblatt eine neue Spalte erstellt wird und diese mit „Numerisches Arbeitsblatt“ beschriftet werden kann, und umgekehrt mit „Numerisches Datum“, indem eine neue Spalte mit der Bezeichnung „Zeichendatum“ erstellt wird. Es scheint so einfach zu sein, aber ich kann etwas so Einfaches tun wie „Eine neue Spalte einfügen“ und dann die Spalte in eine neue Spalte einfügen und umbenennen.
Mithilfe der folgenden Formel können Sie die Spalte „Zeichenarbeitsblatt“ mit der Spalte „Numerisches Datum“ verketten
:Character Worksheet || "_" || Format(
:Numeric Date,
"ddMonyyyy",
9
)
oder durch die Verwendung der Concat()-Funktion
Concat( :Character Worksheet, "_",
Format( :Numeric Date, "ddMonyyyy", 9 )
);
Die Funktion Format() gibt das Datum als Zeichenfolge zurück
Klicken Sie mit der rechten Maustaste oben auf die neue Spalte und wählen Sie die Formel aus dem Popup-Menü aus. Fügen Sie die Formel hinzu, um das zu tun, was Sie brauchen.
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.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.das || ist der Verkettungsoperator. Es gibt eine Reihe von Datumsformaten, aus denen Sie wählen können.
Klicken Sie mit der rechten Maustaste auf eine Spalte -> „Spalteninformationen“, um die Formatnamen normalerweise wiederzufinden. Ich würde empfehlen, Namen zu erstellen, die für die meisten Zwecke gut sortiert sind. Geben Sie wahrscheinlich zuerst das Jahr ein, dann Monat, Tag und zuletzt die Blattnummer. Es sei denn, Sie benötigen alle Blatt 1 zum Zusammensortieren.
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.the datetime formats are in a separate category.the datetime formats are in a separate category.Die Datums-/Uhrzeitformate befinden sich in einer separaten Kategorie.
Hallo allerseits-
Ich bin ein relativ neuer Benutzer von JMP 17 Pro und arbeite an einem Projekt, bei dem ich eine Datenspalte habe, die ich sowohl als Zeichendatentyp als auch als numerischen Datentyp benötigen muss. Ich benötige beide Spalten, da ich 1) zwei verschiedene Spalten miteinander verknüpfen möchte (mithilfe von Zeichen) und gleichzeitig dieselben Daten wie Numerisch in einer zweiten Spalte haben möchte. Wenn ich derzeit die eine Spalte in „Zeichen“ ändere, kann ich die Concat-Funktion erfolgreich verwenden, aber nachdem ich diese erstellt habe, ändere ich die Spalte in „Numerisch“, und meine Concat-Spalte bleibt für mich leer. Ich danke Ihnen für Ihre Hilfe!
