topic Re: Mapping in QlikView https://community.qlik.com/t5/QlikView/Mapping/m-p/1773080#M718101 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132789">@lebontuyau</a>&nbsp; est ce que tu as testé sans Text()</P><P>like :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1610211591112.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46700i150479E8BAF7F156/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_0-1610211591112.png" alt="Taoufiq_Zarra_0-1610211591112.png" /></span></P><P>&nbsp;</P><P>si tu veux l’interpréter comme un text tu peux par exemple faire ;</P><P>MapREFarticle:<BR />Mapping LOAD * INLINE [<BR />From, To<BR />42001C, 42001C PFV<BR />6SMS28FRV7, 6SMS28FRV7 PFV<BR />5370, 5370 PFV<BR />5483, 5483 PFV<BR />5484, 5484 PFV<BR />5486, 5486 PFV<BR />5490, 5490 PFV<BR />5609, 5609 PFV<BR />111881, 111881 PFV<BR />111884, 111884 PFV<BR />112005, 112005 PFV<BR />131142, 131142 PFV<BR />1219634, 1219634 PFV<BR />];</P><P><BR />Data:</P><P>load ApplyMap('MapREFarticle',''&amp;([Ref article])) as [Ref article] inline [<BR />Ref article<BR />5609<BR />];</P><P>résultat :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1610211646570.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46701iD4CA9225359F67AD/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_1-1610211646570.png" alt="Taoufiq_Zarra_1-1610211646570.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 09 Jan 2021 17:01:00 GMT Taoufiq_Zarra 2021-01-09T17:01:00Z Mapping https://community.qlik.com/t5/QlikView/Mapping/m-p/1773076#M718100 <P>Bonjour,</P><P>&nbsp;</P><P>Je rencontre un souci de mapping</P><P>En effet, j'importe un nombre et je désire le mettre en format texte mais impossible, pourtant ma table de mapping est ok je pense, la voici :</P><P>&nbsp;</P><P>MapREFarticle:<BR />Mapping LOAD * INLINE [<BR />From, To</P><P>42001C, 42001C PFV<BR />6SMS28FRV7, 6SMS28FRV7 PFV<BR />5370, 5370 PFV<BR />5483, 5483 PFV<BR />5484, 5484 PFV<BR />5486, 5486 PFV<BR />5490, 5490 PFV<BR />5609, 5609 PFV<BR />111881, 111881 PFV<BR />111884, 111884 PFV<BR />112005, 112005 PFV<BR />131142, 131142 PFV<BR />1219634, 1219634 PFV</P><P>];</P><P>...</P><P>ApplyMap('MapREFarticle',TEXT([Ref article])) as [Ref article],</P><P>...</P><P>Par exemple le chiffre 5609 ne se transforme pas en 5609 PFV</P><P>&nbsp;</P><P>Pourquoi ?</P><P>&nbsp;</P><P>Merci beaucoup</P><P>Cordialement</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 09 Jan 2021 15:50:30 GMT https://community.qlik.com/t5/QlikView/Mapping/m-p/1773076#M718100 lebontuyau 2021-01-09T15:50:30Z Re: Mapping https://community.qlik.com/t5/QlikView/Mapping/m-p/1773080#M718101 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132789">@lebontuyau</a>&nbsp; est ce que tu as testé sans Text()</P><P>like :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1610211591112.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46700i150479E8BAF7F156/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_0-1610211591112.png" alt="Taoufiq_Zarra_0-1610211591112.png" /></span></P><P>&nbsp;</P><P>si tu veux l’interpréter comme un text tu peux par exemple faire ;</P><P>MapREFarticle:<BR />Mapping LOAD * INLINE [<BR />From, To<BR />42001C, 42001C PFV<BR />6SMS28FRV7, 6SMS28FRV7 PFV<BR />5370, 5370 PFV<BR />5483, 5483 PFV<BR />5484, 5484 PFV<BR />5486, 5486 PFV<BR />5490, 5490 PFV<BR />5609, 5609 PFV<BR />111881, 111881 PFV<BR />111884, 111884 PFV<BR />112005, 112005 PFV<BR />131142, 131142 PFV<BR />1219634, 1219634 PFV<BR />];</P><P><BR />Data:</P><P>load ApplyMap('MapREFarticle',''&amp;([Ref article])) as [Ref article] inline [<BR />Ref article<BR />5609<BR />];</P><P>résultat :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1610211646570.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46701iD4CA9225359F67AD/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_1-1610211646570.png" alt="Taoufiq_Zarra_1-1610211646570.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 09 Jan 2021 17:01:00 GMT https://community.qlik.com/t5/QlikView/Mapping/m-p/1773080#M718101 Taoufiq_Zarra 2021-01-09T17:01:00Z