topic Re: Probleme de transformation de table in Francophones https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127537#M2123 <HTML><HEAD></HEAD><BODY><P>thank you for data,</P><P></P><P>data loaded in table test, then :</P><P></P><P>cd_composant:</P><P>load distinct cd_composant resident test;</P><P></P><P>for i = 0 to NoOfRows('cd_composant')-1</P><P></P><P>vcd = peek('cd_composant',i,'cd_composant');</P><P></P><P>$(vcd):</P><P>load cd_composant,dt_tx_pbp_def as&nbsp; dt_tx_pbp_def$(vcd) </P><P>resident test where cd_composant = '$(vcd)';</P><P></P><P></P><P>next i;</P><P></P><P>that gives a table for each cd_composant</P></BODY></HTML> Tue, 28 Aug 2018 10:02:08 GMT ogautier62 2018-08-28T10:02:08Z Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127532#M2118 <HTML><HEAD></HEAD><BODY><P>bonjour la communité <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P><P></P><P>j'ai un probleme avec generic fonction </P><P>mes données sont organiser comme suit : </P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp; cd_composant, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; dt_tx_pbp_def</P><P>FROM bi.[ref_manuel] </P><P>where cd_composant &lt;&gt; ''</P><P>;</P><P>les données :</P><P><SPAN style="font-size: 13.3333px;">cd_composant, <SPAN style="font-size: 13.3333px;">dt_tx_pbp_def</SPAN></SPAN></P><P>Man_depart , AIN</P><P><SPAN style="font-size: 13.3333px;">Man_depart , AIN</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_depart , Allier</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_depart , Alpes</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_CD,Gain</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_CD,Perdu</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_CD,Total</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_Region,Avre</SPAN></P><P><SPAN style="font-size: 13.3333px;">Man_Region,Rhone</SPAN></P><P><SPAN style="font-size: 13.3333px;">....................</SPAN></P><P><SPAN style="font-size: 13.3333px;">ce que je veux faire c'est de transformer cette table en plusieurs tables celon le champs cd_composant donc </SPAN></P><P><SPAN style="font-size: 13.3333px;">une table Man_depart avec un champs Man_depart_dt_tx_pbp_def qui contient [AIN ,Allier,Alpes]</SPAN></P><P><SPAN style="font-size: 13.3333px;">une autre Man_CD ,Man_Region </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">et Merci d'avance pour votre aide <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /><BR /></SPAN></P></BODY></HTML> Tue, 28 Aug 2018 08:23:39 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127532#M2118 bbmmouha 2018-08-28T08:23:39Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127533#M2119 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>tu pourrais procéder en plusieurs étapes de load :</P><P><SPAN style="font-size: 13.3333px;">Man_depart :<BR /></SPAN></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp; cd_composant, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; dt_tx_pbp_def as <SPAN style="font-size: 13.3333px;">Man_depart_dt_tx_pbp_def</SPAN></P><P>FROM bi.[ref_manuel] </P><P>where cd_composant = 'Man_depart';</P><P></P><P>etc</P><P></P><P>cdt</P></BODY></HTML> Tue, 28 Aug 2018 08:53:53 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127533#M2119 ogautier62 2018-08-28T08:53:53Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127534#M2120 <HTML><HEAD></HEAD><BODY><P>merci olivier pour votre réponse </P><P>mais c'été un exemple seulement ma table contien plus que 120 distinct cd_composant <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>donc il faut utiliser un script automatique</P></BODY></HTML> Tue, 28 Aug 2018 08:58:39 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127534#M2120 bbmmouha 2018-08-28T08:58:39Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127535#M2121 <HTML><HEAD></HEAD><BODY><P>pourrais tu fournir un échantillon sous excel d'une vingtaine de lignes avec 3,4 cd composant stp ?</P></BODY></HTML> Tue, 28 Aug 2018 09:13:00 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127535#M2121 ogautier62 2018-08-28T09:13:00Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127536#M2122 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="321"><TBODY><TR><TD height="19" width="83">cd_composant</TD><TD width="155">dt_tx_pbp_def</TD><TD width="83">crunch_date</TD></TR><TR><TD height="19">MAN_CD_GAIN</TD><TD>Perdu</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_CD_GAIN</TD><TD>Gain Normal</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_CD_GAIN</TD><TD>Remboursement Total</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_SPOT</TD><TD>non Spot</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_SPOT</TD><TD>Spot</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_SPOT</TD><TD>Spot Semi-automatique</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Ain</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Aisne</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Allier</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Alpes de Haute-Provence</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Hautes alpes</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Alpes-Maritimes</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Ardèche</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Ardennes</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Ariège</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Aube</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Aude</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Aveyron</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Bouches-du-Rhône</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Calvados</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Cantal</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Charente</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Charente-Maritime</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Cher</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Corrèze</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Côte-d'Or</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Côtes-d'Armor</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Creuse</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Dordogne</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Doubs</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Drôme</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Eure</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Eure-et-Loir</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Finistère</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Corse du Sud</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Haute-Corse</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Gard</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Haute-Garonne</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Gers</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Gironde</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Herault</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Ille-et-Vilaine</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Indre</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Indre-et-Loire</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Isère</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Jura</TD><TD>20180103</TD></TR><TR><TD height="19">MAN_DEPART</TD><TD>Landes</TD><TD>20180103</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 28 Aug 2018 09:38:02 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127536#M2122 bbmmouha 2018-08-28T09:38:02Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127537#M2123 <HTML><HEAD></HEAD><BODY><P>thank you for data,</P><P></P><P>data loaded in table test, then :</P><P></P><P>cd_composant:</P><P>load distinct cd_composant resident test;</P><P></P><P>for i = 0 to NoOfRows('cd_composant')-1</P><P></P><P>vcd = peek('cd_composant',i,'cd_composant');</P><P></P><P>$(vcd):</P><P>load cd_composant,dt_tx_pbp_def as&nbsp; dt_tx_pbp_def$(vcd) </P><P>resident test where cd_composant = '$(vcd)';</P><P></P><P></P><P>next i;</P><P></P><P>that gives a table for each cd_composant</P></BODY></HTML> Tue, 28 Aug 2018 10:02:08 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127537#M2123 ogautier62 2018-08-28T10:02:08Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127538#M2124 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>c'est bien ce que tu souhaitais ?</P></BODY></HTML> Wed, 29 Aug 2018 14:42:15 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127538#M2124 ogautier62 2018-08-29T14:42:15Z Re: Probleme de transformation de table https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127539#M2125 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>le script correspond il bien à ce que tu souhaitais ?</P><P>merci</P></BODY></HTML> Mon, 03 Sep 2018 10:08:11 GMT https://community.qlik.com/t5/Francophones/Probleme-de-transformation-de-table/m-p/127539#M2125 ogautier62 2018-09-03T10:08:11Z