topic fusionner valeurs champ in QlikView https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360874#M417126 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Bonjour, </P><P style="font-size: 13.3333px;">je voudrais fusionner deux valeurs d'un champ pour obtenir une seule valeur </P><P style="font-size: 13.3333px;">Champ Fille d'attente:</P><P style="font-size: 13.3333px;">N1-Annuaire</P><P style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">N2-Certificats&nbsp; -&gt; <SPAN style="color: #ff0000; font-size: 13.3333px;">N2-Certifica<SPAN style="color: #008000;">ts</SPAN> </SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">N2-Certificat -&gt;&nbsp; <SPAN style="color: #ff0000; font-size: 13.3333px;">N2-Certifica<SPAN style="color: #008000;">ts&nbsp; </SPAN></SPAN></SPAN></P><P style="font-size: 13.3333px;">N3-Carte</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">j'ai utilisé la fonction peek match ma ça ne fonctionne pas.</P><P style="font-size: 13.3333px;">Merci </P><P style="font-size: 13.3333px;">Maurice</P></BODY></HTML> Mon, 07 Aug 2017 10:46:23 GMT MauriceLudo 2017-08-07T10:46:23Z fusionner valeurs champ https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360874#M417126 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Bonjour, </P><P style="font-size: 13.3333px;">je voudrais fusionner deux valeurs d'un champ pour obtenir une seule valeur </P><P style="font-size: 13.3333px;">Champ Fille d'attente:</P><P style="font-size: 13.3333px;">N1-Annuaire</P><P style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">N2-Certificats&nbsp; -&gt; <SPAN style="color: #ff0000; font-size: 13.3333px;">N2-Certifica<SPAN style="color: #008000;">ts</SPAN> </SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">N2-Certificat -&gt;&nbsp; <SPAN style="color: #ff0000; font-size: 13.3333px;">N2-Certifica<SPAN style="color: #008000;">ts&nbsp; </SPAN></SPAN></SPAN></P><P style="font-size: 13.3333px;">N3-Carte</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">j'ai utilisé la fonction peek match ma ça ne fonctionne pas.</P><P style="font-size: 13.3333px;">Merci </P><P style="font-size: 13.3333px;">Maurice</P></BODY></HTML> Mon, 07 Aug 2017 10:46:23 GMT https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360874#M417126 MauriceLudo 2017-08-07T10:46:23Z Re: fusionner valeurs champ https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360875#M417127 <HTML><HEAD></HEAD><BODY><P>As a workaround, you can make use of Mapping Load &amp; ApplyMap functionality (refer below given sample code):</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15021033263655041 jive_text_macro" jivemacro_uid="_15021033263655041"> <P>Map_FieldName:</P> <P>Mapping LOAD * INLINE [</P> <P>FieldName, FieldDesc</P> <P>N2-Certificats, N2-Certificats</P> <P>N2-Certificat, N2-Certificats </P> <P>];</P> <P></P> <P></P> <P>Data:</P> <P>LOAD ApplyMap('Map_FieldName', FieldName) AS FieldName INLINE [</P> <P>FieldName</P> <P>N1-Annuaire</P> <P>N2-Certificats</P> <P>N2-Certificat</P> <P>N3-Carte</P> <P>];</P> </PRE><P></P><P>Hope this will be helpful.</P><P></P><P>Regards!</P><P>Rahul Pawar</P></BODY></HTML> Mon, 07 Aug 2017 10:55:44 GMT https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360875#M417127 rahulpawarb 2017-08-07T10:55:44Z Re: fusionner valeurs champ https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360876#M417128 <HTML><HEAD></HEAD><BODY><P>Thank you Rahul,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> 'Fille d'attente' is th field not table and </SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">N1-Annuaire</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #ff0000;">N2-Certificats&nbsp; -&gt; <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">N2-Certifica<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #008000;">ts</SPAN></SPAN></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #ff0000;">N2-Certificat -&gt;&nbsp; <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">N2-Certifica<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #008000;">ts </SPAN></SPAN></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">N3-Carte </P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">is the values of the field </P></BODY></HTML> Mon, 07 Aug 2017 12:25:27 GMT https://community.qlik.com/t5/QlikView/fusionner-valeurs-champ/m-p/1360876#M417128 MauriceLudo 2017-08-07T12:25:27Z