topic Re: Fazer join... in Brasil https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586945#M16388 <HTML><HEAD></HEAD><BODY><P>Obrigado foi muito útil....abraços... </P></BODY></HTML> Tue, 01 Apr 2014 14:05:03 GMT 2014-04-01T14:05:03Z Fazer join... https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586943#M16386 <HTML><HEAD></HEAD><BODY><P>Bom dia pessoal,</P><P></P><P>Preciso fazer um outer join entre duas tabelas.</P><P></P><P>TabRedZ:</P><P>LOAD&nbsp; %ChaveZ, //chave para ser usada</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_CANCEL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; AnoZ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; MesZ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; DataZ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_FILIAL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_HRREDZ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_PDV, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_SERPDV, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FI_VALCON</P><P>FROM</P><P>Reducao*.QVD</P><P>(qvd);</P><P></P><P>TabMFD:</P><P>LOAD&nbsp; %ChaveZ,&nbsp;&nbsp;&nbsp; ///chave para ser usada</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AliqMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CupomMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ano, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CodEmpFil, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Mes, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Dia, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Data, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; DiaSemana, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Trimestre, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; MesAno, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ItemMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; PdvMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ImpressMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; DescProdutoMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; QuantidadeMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; StatusMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; TipoMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ValBaseIcmMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ValorIcmMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; TotalMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ValorDescMFD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ValorUniMFD</P><P>FROM</P><P>MFD*.QVD</P><P>(qvd);</P></BODY></HTML> Tue, 01 Apr 2014 13:43:12 GMT https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586943#M16386 2014-04-01T13:43:12Z Re: Fazer join... https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586944#M16387 <HTML><HEAD></HEAD><BODY><P>Olá, faça assim:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro _jivemacro_uid_13963604934576558 jive_macro_code" jivemacro_uid="_13963604934576558"> <P>TabRedZ:</P> <P>LOAD&nbsp; %ChaveZ, //chave para ser usada</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_CANCEL, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; AnoZ, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; MesZ, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DataZ, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_FILIAL, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_HRREDZ, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_PDV, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_SERPDV, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; FI_VALCON</P> <P>FROM</P> <P>Reducao*.QVD</P> <P>(qvd);</P> <P></P> <P>TabMFD:</P> <P>Join (TabRedZ)</P> <P>LOAD&nbsp; %ChaveZ,&nbsp;&nbsp;&nbsp; ///chave para ser usada</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AliqMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; CupomMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Ano, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; CodEmpFil, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Mes, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Dia, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Data, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DiaSemana, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Trimestre, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; MesAno, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ItemMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; PdvMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ImpressMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DescProdutoMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; QuantidadeMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; StatusMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; TipoMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ValBaseIcmMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ValorIcmMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; TotalMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ValorDescMFD, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ValorUniMFD</P> <P>FROM</P> <P>MFD*.QVD</P> <P>(qvd);</P> </PRE><P></P><P>o padrão do Join no QlikView é Full Outer Join.</P><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Tue, 01 Apr 2014 13:55:53 GMT https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586944#M16387 fernando_tonial 2014-04-01T13:55:53Z Re: Fazer join... https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586945#M16388 <HTML><HEAD></HEAD><BODY><P>Obrigado foi muito útil....abraços... </P></BODY></HTML> Tue, 01 Apr 2014 14:05:03 GMT https://community.qlik.com/t5/Brasil/Fazer-join/m-p/586945#M16388 2014-04-01T14:05:03Z