cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-384501%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EActualizar%20una%20tabla%20de%20datos%20JMP%20que%20se%20hab%C3%ADa%20llenado%20previamente%20con%20datos%20importados%20de%20un%20archivo%20.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384501%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%20comunidad%20de%20JMP%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENecesito%20ayuda%20para%20actualizar%20una%20tabla%20de%20datos%20JMP%20que%20se%20complet%C3%B3%20previamente%20con%20el%3CEM%3E%3CSTRONG%3E%20Archivo%20-%26gt%3B%20Abrir%20-%26gt%3B%20Archivo%20de%20texto%3C%2FSTRONG%3E%3C%2FEM%3E%20opci%C3%B3n%20de%20importaci%C3%B3n%2C%20en%20este%20caso%20una%3CEM%3E%20.csv%3C%2FEM%3E%20expediente.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELa%20primera%20vez%2C%20los%20datos%20se%20importaron%20sin%20problemas%2C%20luego%20agregu%C3%A9%20un%20par%20de%20f%C3%B3rmulas%20de%20columna%20al%20final%20y%20realic%C3%A9%20algunos%20gr%C3%A1ficos%20usando%20el%20Generador%20de%20gr%C3%A1ficos%2C%20que%20guard%C3%A9%20el%20script%20en%20la%20tabla%20de%20datos%20y%20el%20archivo%20como%20de%20costumbre.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAl%20d%C3%ADa%20siguiente%2C%20como%20s%C3%A9%20el%3CEM%3E%20.csv%3C%2FEM%3E%20El%20archivo%20se%20llen%C3%B3%20con%20m%C3%A1s%20datos%2C%20volv%C3%AD%20a%20la%20tabla%20de%20datos%20JMP%20y%20volv%C3%AD%20a%20ejecutar%20el%20script%20'fuente'%20para%20actualizarlo.%20%C2%BFResulta%20que%20crea%20una%20nueva%20tabla%20de%20datos%20JMP%2C%20con%20los%20datos%20m%C3%A1s%20recientes%2C%20pero%20las%20f%C3%B3rmulas%20de%20columna%20originales%20y%20los%20scripts%20para%20los%20gr%C3%A1ficos%20ya%20no%20est%C3%A1n%20disponibles%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETambi%C3%A9n%20prob%C3%A9%20el%20m%C3%A9todo%20MFI%2C%20aunque%20solo%20importa%20el%20mismo%20archivo%20cada%20vez%2C%20pero%20obtengo%20el%20mismo%20resultado.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%BFHay%20alguna%20manera%20de%20simplemente%20actualizar%20la%20tabla%20de%20datos%20original%20y%20mantener%20todo%20lo%20dem%C3%A1s%20como%20estaba%2C%20como%20podemos%20hacer%20a%20trav%C3%A9s%20del%20script%20de%20consulta%20de%20la%20base%20de%20datos%20'Actualizar%20desde%20la%20base%20de%20datos'%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGracias%20de%20antemano%20por%20tu%20ayuda.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaludos%2C%3C%2FP%3E%3CP%3EVasco%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-384501%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3ETabla%20de%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-384592%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Actualizar%20una%20tabla%20de%20datos%20JMP%20que%20se%20hab%C3%ADa%20llenado%20previamente%20con%20datos%20importados%20de%20un%20archivo%20.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384592%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%2C%20vea%20si%20esto%20funciona%20para%20usted%3A%20permita%20que%20JMP%20cree%20la%20nueva%20tabla%2C%20pero%20luego%20copie%20su%20contenido%20en%20la%20tabla%20original.%3C%2FP%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%0A%3CP%3ESalud%2C%3C%2FP%3E%0A%3CP%3EBrady%3C%2FP%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adta%20%3D%20datatable(%22a%22)%3B%20%20%20%20%20%2F%2Fthe%20original%20table%20with%20all%20of%20the%20goodies%0A%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2F%2Fget%20the%20new%20table%20by%20whatever%20means%0Adtb%20%3D%20datatable(%22b%22)%3B%20%20%20%20%20%20%2F%2Fthe%20update%20table%0A%0Adta%20%26lt%3B%26lt%3B%20add%20rows(nrow(dtb)%20-%20nrow(dta))%3B%0Adta%5B0%2C0%5D%20%3D%20dtb%5B0%2C0%5D%3B%0A%0Aclose(dtb%2C%20nosave)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%26nbsp%3B%3C%2FCODE%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
VCO
VCO
Level III

Refresh a JMP data table that had been previously populated with data imported from a .csv file

Hello JMP community,

 

I need some help with refreshing of a JMP data table that was previously populated using the File -> Open -> Text File import option, in this case a .csv file.

 

The first time, the data got imported with no issues, I then added a couple of column formulas at the end and done some graphs using the Graph Builder, which I saved the script to the data table and the file as normal.

 

The following day, as I know the .csv file got populated with more data, I went back to the JMP data table and re-ran the 'source' script to update it. It turns out that it creates a new JMP data table, with the newest data, but the original column formulas and scripts for the graphs are not available anymore?

 

I tried the MFI method too, even though it's just importing the same file every time, but I get the same result.

 

Is there a way to simply refresh the original data table, and keep everything else as it was, like we can do via the database query script 'Update from Database' ?

 

Thanks in advance for your help.

 

Regards,

Vasco

2 REPLIES 2

Re: Refresh a JMP data table that had been previously populated with data imported from a .csv file

Hi, see if this works for you: allow JMP to build the new table, but then copy its contents into the original table.

Cheers,

Brady

Names Default To Here(1);

dta = datatable("a");					//the original table with all of the goodies

														//get the new table by whatever means
dtb = datatable("b");			 		//the update table

dta << add rows(nrow(dtb) - nrow(dta));
dta[0,0] = dtb[0,0];

close(dtb, nosave);

 

 

 

VCO
VCO
Level III

Re: Refresh a JMP data table that had been previously populated with data imported from a .csv file

Hi Brady,

 

Thanks for your reply and apologies for the late feedback.

 

I ended up finding that using the 'JMP Query Builder' under the menu 'Tables' does the job. It also has the additional benefit of using a similar UI as the 'Database Query Builder', which is also handy.

 

Thanks,

Vasco