cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-779810%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EConsenti%20alla%20piattaforma%20di%20aggiornamento%20di%20creare%20nuove%20colonne%20se%20sono%20gi%C3%A0%20presenti%20nella%20tabella%20da%20aggiornare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779810%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CSTRONG%3ECosa%20ti%20ha%20ispirato%20a%20richiedere%20questa%20lista%20dei%20desideri%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EUtilizzo%20della%20piattaforma%20di%20aggiornamento%20JMP%20e%20ricezione%20di%20messaggi%20di%20errore.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EQuale%20miglioramento%20vorresti%20vedere%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ESe%20l'utente%20ha%20definito%20delle%20colonne%20da%20aggiungere%20e%20ha%20scelto%20di%20NON%20sostituire%20nessuna%20di%20quelle%20aggiunte%2C%20aggiungerle%20come%20nuove%20colonne%20con%20indice.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EErrore%3A%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt1%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%2C%20Invisible)%3B%0Adt2%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class%20Families.jmp%22%2C%20Invisible)%3B%0A%0Adt1%20%26lt%3B%26lt%3B%20Update(%0A%09With(dt2)%2C%0A%09Match%20Columns(%3Aname%20%3D%20%3Aname)%2C%0A%09Add%20Columns%20from%20Update%20Table(%3Aage)%2C%0A%09Replace%20Columns%20in%20Main%20Table(None)%0A)%3B%0A%0AClose(dt1%2C%20no%20save)%3B%0AClose(dt2%2C%20no%20save)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ema%20vorrei%20finire%20con%20due%20colonne%20et%C3%A0%3A%20%3CSTRONG%3Eet%C3%A0%3C%2FSTRONG%3E%20originale%20e%20%3CSTRONG%3Eet%C3%A0%202%3C%2FSTRONG%3E%20appena%20creata%20dal%20dt2.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPerch%C3%A9%20questa%20idea%20%C3%A8%20importante%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ERende%20l'utilizzo%20di%20Update%20pi%C3%B9%20flessibile%20senza%20dover%20ricorrere%20alla%20ridenominazione%20delle%20colonne%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779810%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomazione%20e%20scripting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccesso%20ai%20dati%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFusione%20e%20pulizia%20dei%20dati%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798031%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Consenti%20alla%20piattaforma%20di%20aggiornamento%20di%20creare%20nuove%20colonne%20se%20sono%20gi%C3%A0%20presenti%20nella%20tabella%20da%20aggiornare%20-%20Stato%20modificato%20in%3A%20Riconosciuto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798031%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798032%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Consenti%20alla%20piattaforma%20di%20aggiornamento%20di%20creare%20nuove%20colonne%20se%20sono%20gi%C3%A0%20presenti%20nella%20tabella%20da%20aggiornare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798032%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Epotresti%20usare%20Tables%2FJoin%20invece%20di%20Tables%2FUpdate.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJoin%20offre%20la%20possibilit%C3%A0%20di%20scegliere%20tra%20l'unione%20delle%20colonne%20e%20il%20mantenimento%20di%20entrambe.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
0 Kudos

Allow Update platform to create new columns if they already exist in the table to be updated

What inspired this wish list request? 

Using JMP's Update platform and getting error messages.

 

 

What is the improvement you would like to see? 

If user has defined columns to be added and chose NOT to replace any of those added columns, add them as new columns with index.

 

Error:

 

Names Default To Here(1);

dt1 = Open("$SAMPLE_DATA/Big Class.jmp", Invisible);
dt2 = Open("$SAMPLE_DATA/Big Class Families.jmp", Invisible);

dt1 << Update(
	With(dt2),
	Match Columns(:name = :name),
	Add Columns from Update Table(:age),
	Replace Columns in Main Table(None)
);

Close(dt1, no save);
Close(dt2, no save);

but I would like to end up with two age columns: original age and newly created age 2 from the dt2.

 

 

 

Why is this idea important? 

Makes using Update more flexible without having to rely on renaming columns

 

 

2 Comments
Status changed to: Acknowledged
 
hogi
Level XII

you could use Tables/Join instead of Tables/Update.

 

Join provides an option to choose between merging columns and keeping both columns.