topic Cambiar valores de campos en load in QlikView https://community.qlik.com/t5/QlikView/Cambiar-valores-de-campos-en-load/m-p/621718#M1096191 <HTML><HEAD></HEAD><BODY><P>hola como están?</P><P>por favor me pueden dar una mano con lo que estoy intentando hacer, quiero modificar los valores de dos campos al momento de hacer la carga de los datos; cuanto con tabla ya cargada en QV y se tiene que cambiar los valores de dos campos de acuerdo a los valores de otra tabla. </P><P></P><P>ejemplo:</P><P>los valores de los campos Codigo y Almacen OC de la tabla cargada debe de cambiar por el valor de Almacen Destino de la tabla valores a cambiar, de acuerdo a la combinación de los campos Contro OC y Almacen OC.</P><P></P><P>201205#FP08#<SPAN style="color: #ff0000;"><STRONG>L001</STRONG></SPAN>#210574&nbsp;&nbsp;&nbsp;&nbsp; FP08&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"><STRONG>L001</STRONG></SPAN>&nbsp; debería de cambiar a 201205#FP08#<SPAN style="color: #ff0000;"><STRONG>L002</STRONG></SPAN>#210574&nbsp;&nbsp;&nbsp;&nbsp; FP08&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #ff0000;">L002</STRONG></P><P><SPAN style="color: #000000;">(primer registro de ambas tablas)</SPAN></P><P></P><P>tabla cargada</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 323px;"><TBODY><TR><TD height="20" width="171">Codigo</TD><TD width="70">Centro OC</TD><TD width="82">Almacen OC</TD></TR><TR><TD height="20">201205#FP08#L001#210574</TD><TD>FP08</TD><TD>L001</TD></TR><TR><TD height="20">201205#FP09#T008#210576</TD><TD>FP09</TD><TD>T008</TD></TR><TR><TD height="20">201205#FP09#T011#211315</TD><TD>FP09</TD><TD>T011</TD></TR><TR><TD height="20">201205#FP10#L003#288991</TD><TD>FP10</TD><TD>L003</TD></TR><TR><TD height="20">201205#FP11#L003#289768</TD><TD>FP11</TD><TD>L003</TD></TR><TR><TD height="20">201205#FP12#L001#290296</TD><TD>FP12</TD><TD>L001</TD></TR><TR><TD height="20">201205#FS14#L003#296740</TD><TD>FS14</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS18#L003#299161</TD><TD>FS18</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS19#L003#299162</TD><TD>FS19</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS20#L003#319060</TD><TD>FS20</TD><TD>L003</TD></TR></TBODY></TABLE><P></P><P>tabla con valores a cambiar</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 265px;"><TBODY><TR><TD height="20" width="70">Centro OC</TD><TD width="82">Almacen OC</TD><TD style="background-color: #ccffcc;" width="113">Almacen Destino</TD></TR><TR><TD height="20">FP08</TD><TD>L001</TD><TD style="background-color: #ccffcc;">L002</TD></TR><TR><TD height="20">FP09</TD><TD>T008</TD><TD style="background-color: #ccffcc;">F008</TD></TR><TR><TD height="20">FP09</TD><TD>T011</TD><TD style="background-color: #ccffcc;">F011</TD></TR><TR><TD height="20">FP10</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FP11</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FP12</TD><TD>L001</TD><TD style="background-color: #ccffcc;">L002</TD></TR><TR><TD height="20">FS14</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS18</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS19</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS20</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR></TBODY></TABLE><P></P><P>gracias por sus comentarios.</P></BODY></HTML> Fri, 25 Apr 2014 14:50:31 GMT 2014-04-25T14:50:31Z Cambiar valores de campos en load https://community.qlik.com/t5/QlikView/Cambiar-valores-de-campos-en-load/m-p/621718#M1096191 <HTML><HEAD></HEAD><BODY><P>hola como están?</P><P>por favor me pueden dar una mano con lo que estoy intentando hacer, quiero modificar los valores de dos campos al momento de hacer la carga de los datos; cuanto con tabla ya cargada en QV y se tiene que cambiar los valores de dos campos de acuerdo a los valores de otra tabla. </P><P></P><P>ejemplo:</P><P>los valores de los campos Codigo y Almacen OC de la tabla cargada debe de cambiar por el valor de Almacen Destino de la tabla valores a cambiar, de acuerdo a la combinación de los campos Contro OC y Almacen OC.</P><P></P><P>201205#FP08#<SPAN style="color: #ff0000;"><STRONG>L001</STRONG></SPAN>#210574&nbsp;&nbsp;&nbsp;&nbsp; FP08&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"><STRONG>L001</STRONG></SPAN>&nbsp; debería de cambiar a 201205#FP08#<SPAN style="color: #ff0000;"><STRONG>L002</STRONG></SPAN>#210574&nbsp;&nbsp;&nbsp;&nbsp; FP08&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #ff0000;">L002</STRONG></P><P><SPAN style="color: #000000;">(primer registro de ambas tablas)</SPAN></P><P></P><P>tabla cargada</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 323px;"><TBODY><TR><TD height="20" width="171">Codigo</TD><TD width="70">Centro OC</TD><TD width="82">Almacen OC</TD></TR><TR><TD height="20">201205#FP08#L001#210574</TD><TD>FP08</TD><TD>L001</TD></TR><TR><TD height="20">201205#FP09#T008#210576</TD><TD>FP09</TD><TD>T008</TD></TR><TR><TD height="20">201205#FP09#T011#211315</TD><TD>FP09</TD><TD>T011</TD></TR><TR><TD height="20">201205#FP10#L003#288991</TD><TD>FP10</TD><TD>L003</TD></TR><TR><TD height="20">201205#FP11#L003#289768</TD><TD>FP11</TD><TD>L003</TD></TR><TR><TD height="20">201205#FP12#L001#290296</TD><TD>FP12</TD><TD>L001</TD></TR><TR><TD height="20">201205#FS14#L003#296740</TD><TD>FS14</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS18#L003#299161</TD><TD>FS18</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS19#L003#299162</TD><TD>FS19</TD><TD>L003</TD></TR><TR><TD height="20">201205#FS20#L003#319060</TD><TD>FS20</TD><TD>L003</TD></TR></TBODY></TABLE><P></P><P>tabla con valores a cambiar</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 265px;"><TBODY><TR><TD height="20" width="70">Centro OC</TD><TD width="82">Almacen OC</TD><TD style="background-color: #ccffcc;" width="113">Almacen Destino</TD></TR><TR><TD height="20">FP08</TD><TD>L001</TD><TD style="background-color: #ccffcc;">L002</TD></TR><TR><TD height="20">FP09</TD><TD>T008</TD><TD style="background-color: #ccffcc;">F008</TD></TR><TR><TD height="20">FP09</TD><TD>T011</TD><TD style="background-color: #ccffcc;">F011</TD></TR><TR><TD height="20">FP10</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FP11</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FP12</TD><TD>L001</TD><TD style="background-color: #ccffcc;">L002</TD></TR><TR><TD height="20">FS14</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS18</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS19</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR><TR><TD height="20">FS20</TD><TD>L003</TD><TD style="background-color: #ccffcc;">L001</TD></TR></TBODY></TABLE><P></P><P>gracias por sus comentarios.</P></BODY></HTML> Fri, 25 Apr 2014 14:50:31 GMT https://community.qlik.com/t5/QlikView/Cambiar-valores-de-campos-en-load/m-p/621718#M1096191 2014-04-25T14:50:31Z