cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-437747%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EAgregue%20una%20opci%C3%B3n%20para%20evitar%20la%20creaci%C3%B3n%20inesperada%20de%20nuevas%20columnas%20a%20partir%20de%20variables%20de%20tabla%20en%20concatenaci%C3%B3n.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-437747%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EDespu%C3%A9s%20de%20ejecutar%20este%20script%2C%20dt3%20contendr%C3%A1%20una%20columna%20'a'.%20Cuando%20se%20utiliza%20concatenar%20en%20una%20secuencia%20de%20comandos%2C%20esto%20puede%20provocar%20un%20comportamiento%20inesperado%20o%20la%20necesidad%20de%20eliminar%20manualmente%20variables%20que%20no%20se%20utilizan%20en%20la%20tabla.%20(Ejemplo%3A%20la%20variable%20de%20tabla%20'SQL'%20se%20agrega%20autom%C3%A1ticamente%20a%20las%20tablas%20devueltas%20por%20consultas%20SQL).%20Proporcione%20una%20opci%C3%B3n%20en%20Concatenate()%20para%20cambiar%20el%20nombre%20de%20las%20variables%20de%20tabla%20duplicadas%20antes%20de%20la%20concatenaci%C3%B3n%20si%20dar%C3%ADan%20como%20resultado%20una%20nueva%20columna.%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%20New%20Table(%20%22Test%22%2C%20Add%20Rows(1)%2C%20New%20Table%20Variable(%20%22a%22%2C%201%20)%20)%3B%0Adt2%20%3D%20New%20Table(%20%22Test%22%2C%20Add%20Rows(1)%2C%20New%20Table%20Variable(%20%22a%22%2C%202%20)%20)%3B%0A%0Adt3%20%3D%20dt1%20%26lt%3B%26lt%3B%20Concatenate(%20dt2%20)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-437747%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomatizaci%C3%B3n%20y%20secuencias%20de%20comandos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

Add option to prevent unexpected new column creation from table variables in concatenate.

After running this script dt3 will contain a column 'a'. When using concatenate in a script this can result in unexpected behavior or the need to manually remove variables that are not used in the table. (Example: the 'SQL' table variable automatically added to tables returned from SQL Queries.) Provide an option in Concatenate() to rename duplicate table variables before concatenation if they would result in a new column. 

 

Names default to here(1);

dt1 = New Table( "Test", Add Rows(1), New Table Variable( "a", 1 ) );
dt2 = New Table( "Test", Add Rows(1), New Table Variable( "a", 2 ) );

dt3 = dt1 << Concatenate( dt2 );