topic Re: DePara in Brasil https://community.qlik.com/t5/Brasil/DePara/m-p/125987#M6874 <HTML><HEAD></HEAD><BODY><P>Sempre à disposição meu nobre! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Wed, 03 Oct 2018 15:03:54 GMT Thiago_Justen_ 2018-10-03T15:03:54Z DePara https://community.qlik.com/t5/Brasil/DePara/m-p/125983#M6870 <HTML><HEAD></HEAD><BODY><P>Ola</P><P></P><P>Preciso fazer um DePara entre duas tabelas, onde a a fato possui o nome de Vendedores (do jeito que foram cadastrados) com suas respectivas oportunidades (Vendas) e na outra uma lista com os possiveis Nomes (cadastrados) e seus respectivos Nomes Corretos.</P><P></P><P>Ex:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Vendedor</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Oportunidade</STRONG></TH></TR><TR><TD style="padding: 2px;">Allán</TD><TD style="padding: 2px;">Mercadinho da vila</TD></TR><TR><TD style="padding: 2px;">Allan</TD><TD style="padding: 2px;">Mercadinho da esquina</TD></TR><TR><TD style="padding: 2px;"><P>João</P></TD><TD style="padding: 2px;">Mercadinho do centro</TD></TR><TR><TD style="padding: 2px;">Joao</TD><TD style="padding: 2px;">Mercadinho</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Nomes</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Nome Correto</TH></TR><TR><TD style="padding: 2px;">Allán</TD><TD style="padding: 2px;">Allan</TD></TR><TR><TD style="padding: 2px;">Allan</TD><TD style="padding: 2px;">Allan</TD></TR><TR><TD style="padding: 2px;">João</TD><TD style="padding: 2px;">João</TD></TR><TR><TD style="padding: 2px;">Joao</TD><TD style="padding: 2px;">João</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 01 Oct 2018 20:39:18 GMT https://community.qlik.com/t5/Brasil/DePara/m-p/125983#M6870 Anonymous 2018-10-01T20:39:18Z Re: DePara https://community.qlik.com/t5/Brasil/DePara/m-p/125984#M6871 <HTML><HEAD></HEAD><BODY><P>podes usar o applymap()</P><P></P><P></P><P><A href="https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctions/ApplyMap.htm?tr=pt-BR" title="https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctions/ApplyMap.htm?tr=pt-BR">https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctions/ApplyMap.htm?tr=pt-BR</A></P></BODY></HTML> Tue, 02 Oct 2018 01:47:20 GMT https://community.qlik.com/t5/Brasil/DePara/m-p/125984#M6871 afurtado 2018-10-02T01:47:20Z Re: DePara https://community.qlik.com/t5/Brasil/DePara/m-p/125985#M6872 <HTML><HEAD></HEAD><BODY><P>Luis,</P><P></P><P>Com o que o Alessandro sugeriu o script ficaria assim:</P><P></P><P><EM>//Crie a tabela de mapeamento</EM></P><P><STRONG>Nomes:</STRONG></P><P>Mapping</P><P>Load</P><P>Nomes,</P><P>[Nome Correto]</P><P>From suaBase;</P><P></P><P><STRONG>Fato:</STRONG></P><P>Load</P><P><STRONG>ApplyMap('Nomes','Vendedor)&nbsp;&nbsp;&nbsp;&nbsp; as Vendedor, </STRONG></P><P>Oportunidade</P><P>From suaBase;</P></BODY></HTML> Tue, 02 Oct 2018 11:11:26 GMT https://community.qlik.com/t5/Brasil/DePara/m-p/125985#M6872 Thiago_Justen_ 2018-10-02T11:11:26Z Re: DePara https://community.qlik.com/t5/Brasil/DePara/m-p/125986#M6873 <HTML><HEAD></HEAD><BODY><P>Perfeito, Thiago!</P><P></P><P>muito obrigado.</P></BODY></HTML> Tue, 02 Oct 2018 17:35:52 GMT https://community.qlik.com/t5/Brasil/DePara/m-p/125986#M6873 Anonymous 2018-10-02T17:35:52Z Re: DePara https://community.qlik.com/t5/Brasil/DePara/m-p/125987#M6874 <HTML><HEAD></HEAD><BODY><P>Sempre à disposição meu nobre! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Wed, 03 Oct 2018 15:03:54 GMT https://community.qlik.com/t5/Brasil/DePara/m-p/125987#M6874 Thiago_Justen_ 2018-10-03T15:03:54Z