topic Re: Setar Flag em duplicados in Brasil https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312031#M47309 <HTML><HEAD></HEAD><BODY><P>Amigo, segue exemplo;</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14966705274973388 jive_text_macro" jivemacro_uid="_14966705274973388"> <P>Tab_Temp:</P> <P>Load *</P> <P>&nbsp; Inline [</P> <P>&nbsp; SAP_FILIAL,SAP_MATRIZ</P> <P>&nbsp; 1,1</P> <P>&nbsp; 2,1</P> <P>&nbsp; 3,2</P> <P>&nbsp; 3,1</P> <P>&nbsp; 4,1</P> <P>&nbsp; 5,1</P> <P>&nbsp; 5,2</P> <P>];</P> <P></P> <P>Tab_Matriz:</P> <P>Load </P> <P>&nbsp; SAP_FILIAL, </P> <P>&nbsp; SAP_MATRIZ, </P> <P>&nbsp; If( SAP_FILIAL = Previous(SAP_FILIAL), 0, 1) As 'Flag'&nbsp;&nbsp; </P> <P>&nbsp; Resident Tab_Temp Order By SAP_FILIAL Asc;</P> <P>Drop Table Tab_Temp;</P> </PRE></BODY></HTML> Mon, 05 Jun 2017 13:48:47 GMT mario_sergio_ti 2017-06-05T13:48:47Z Setar Flag em duplicados https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312030#M47308 <HTML><HEAD></HEAD><BODY><P>Bom dia,</P><P></P><P>Tenho uma tabela que apresenta 2 campos, SAP_FILIAL e SAP_MATRIZ. De vez em quando acontece de uma filial ter 2 matrizes, o que duplica sua base. Para evitar isso, queria criar um flag que deixa 1 para todas as filiais e, qdo duplicado, a segunda linha fique 0.</P><P></P><P>Exemplo:</P><P></P><P>SAP_FILIAL&nbsp;&nbsp; |&nbsp;&nbsp; SAP_MATRIZ&nbsp; |&nbsp; Flag</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>6 ....</P><P></P><P>É possivel? Como nao importa muito quem ficará como matriz, o importante é nao ter duplicados na SAP_FILIAL.</P><P></P><P>obs: Processo na carga.</P><P></P><P>André</P></BODY></HTML> Mon, 05 Jun 2017 13:12:41 GMT https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312030#M47308 AndreFrencl 2017-06-05T13:12:41Z Re: Setar Flag em duplicados https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312031#M47309 <HTML><HEAD></HEAD><BODY><P>Amigo, segue exemplo;</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14966705274973388 jive_text_macro" jivemacro_uid="_14966705274973388"> <P>Tab_Temp:</P> <P>Load *</P> <P>&nbsp; Inline [</P> <P>&nbsp; SAP_FILIAL,SAP_MATRIZ</P> <P>&nbsp; 1,1</P> <P>&nbsp; 2,1</P> <P>&nbsp; 3,2</P> <P>&nbsp; 3,1</P> <P>&nbsp; 4,1</P> <P>&nbsp; 5,1</P> <P>&nbsp; 5,2</P> <P>];</P> <P></P> <P>Tab_Matriz:</P> <P>Load </P> <P>&nbsp; SAP_FILIAL, </P> <P>&nbsp; SAP_MATRIZ, </P> <P>&nbsp; If( SAP_FILIAL = Previous(SAP_FILIAL), 0, 1) As 'Flag'&nbsp;&nbsp; </P> <P>&nbsp; Resident Tab_Temp Order By SAP_FILIAL Asc;</P> <P>Drop Table Tab_Temp;</P> </PRE></BODY></HTML> Mon, 05 Jun 2017 13:48:47 GMT https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312031#M47309 mario_sergio_ti 2017-06-05T13:48:47Z Re: Setar Flag em duplicados https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312032#M47310 <HTML><HEAD></HEAD><BODY><P>Bom dia André,</P><P></P><P>Segue um exemplo de como pode ser feito.</P><P></P><P>Att,</P><P></P><P>Felipe.</P></BODY></HTML> Mon, 05 Jun 2017 13:50:28 GMT https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312032#M47310 felipedl 2017-06-05T13:50:28Z Re: Setar Flag em duplicados https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312033#M47311 <HTML><HEAD></HEAD><BODY><P>Você pode também usar assim</P><P></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP_FILIAL,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp;&nbsp; SAP_MATRIZ,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp;&nbsp; If(Autonumber(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP_FILIAL,<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP_MATRIZ)=1,1,0) as FLAG</SPAN></SPAN></SPAN></P><P>From SEUQVD(qvd);</P></BODY></HTML> Mon, 05 Jun 2017 16:44:42 GMT https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312033#M47311 Clever_Anjos 2017-06-05T16:44:42Z Re: Setar Flag em duplicados https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312034#M47312 <HTML><HEAD></HEAD><BODY><P>Mario, funcionou beleza !! Obrigado aos demais também!! André</P></BODY></HTML> Mon, 05 Jun 2017 16:49:48 GMT https://community.qlik.com/t5/Brasil/Setar-Flag-em-duplicados/m-p/1312034#M47312 AndreFrencl 2017-06-05T16:49:48Z