2401_es-ES
Accediendo simultáneamente a 2 columnas con el mismo nombre de 2 tablas de datosTengo dos archivos de datos que tienen, por diseño, los mismos nombres de columna. ¿Cómo hago referencia a cada columna en una declaración IF, para evitar una referencia ambigua ...
Quiero poder hacer algo como esto ....
IF (dt1.weight == dt2.weight,Re: Acceso simultáneo a 2 columnas con el mismo nombre de 2 tablas de datos
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; color: black; font-family: Helvetica, Arial, sans-serif;"> You
puede usar la función de columna
style = "font-size: 10pt; color: navy; font-family: Helvetica, Arial, sans-serif;">:
style = "font-size: 10pt; color: negro; font-family: Helvetica, Arial, sans-serif;">
style = "font-family: Helvetica, Arial, sans-serif;">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> c1
style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> =
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: rgb (0, 0, 221);"> column
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> (
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> dt1
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">,
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: púrpura;"> "Peso"
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">)
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; color: verde;"> //
se refiere a la columna de peso en la tabla dt1
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> c2
style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> =
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: rgb (0, 0, 221);"> column
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> (
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> dt2
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">,
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: púrpura;"> "Peso"
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">)
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; color: verde;"> //
se refiere a la columna de peso en la tabla dt2
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; font-family:" Courier New "; color: negro;"> c1
style = "font-size: 10pt; font-family:" Courier New "; color: navy;"> <<
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
conjunto seleccionado
style = "font-size: 10pt; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; font-family:" Courier New "; color: verde;"> //
Selecciona el peso de la columna en la tabla dt1.
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: negro;"> c2
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: navy;"> <<
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: negro;">
conjunto seleccionado
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: navy;">;
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: negro;">
style = "">
style = "font-size: 10pt; line-height: 115%; font-family:" Courier New "; color: verde;"> //
Selecciona el peso de la columna en dt2.
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
style = "font-family: Helvetica, Arial, sans-serif;">
Saludos,
style = "font-family: Helvetica, Arial, sans-serif;">
style = "font-family: Helvetica, Arial, sans-serif;"> Peter
style = "font-size: 10pt; font-family:" Courier New "; color: negro;">
