topic Re: remove numeric columns from table in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383300#M8256 <HTML><HEAD></HEAD><BODY><P>Is this one column including 4 characters or 4 different columns?</P><P>a&nbsp; 2&nbsp; 5&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>b&nbsp; 4&nbsp;&nbsp; 6&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>c&nbsp;&nbsp; 6&nbsp;&nbsp; 7&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp; 8&nbsp;&nbsp; 3&nbsp; h </P></BODY></HTML> Tue, 28 Nov 2017 09:04:47 GMT shraddha_g 2017-11-28T09:04:47Z remove numeric columns from table https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383297#M8253 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P></P><P>How to remove numerical columns from table and have separate table for it in qlik sense</P><P></P><P>i.e.</P><P>Table 1 into table1 &amp; table2</P><P>a&nbsp; 2&nbsp; 5&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a 2 5</P><P>b&nbsp; 4&nbsp;&nbsp; 6&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b 4 6</P><P>c&nbsp;&nbsp; 6&nbsp;&nbsp; 7&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c 6 7</P><P>d&nbsp;&nbsp; 8&nbsp;&nbsp; 3&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d 8 3</P></BODY></HTML> Tue, 28 Nov 2017 05:35:19 GMT https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383297#M8253 Anonymous 2017-11-28T05:35:19Z Re: remove numeric columns from table https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383298#M8254 <HTML><HEAD></HEAD><BODY><P>What is the expected output?</P></BODY></HTML> Tue, 28 Nov 2017 05:40:12 GMT https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383298#M8254 shraddha_g 2017-11-28T05:40:12Z Re: remove numeric columns from table https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383299#M8255 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a 2 5</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b 4 6</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c 6 7</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d 8 3</P></BODY></HTML> Tue, 28 Nov 2017 06:08:34 GMT https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383299#M8255 Anonymous 2017-11-28T06:08:34Z Re: remove numeric columns from table https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383300#M8256 <HTML><HEAD></HEAD><BODY><P>Is this one column including 4 characters or 4 different columns?</P><P>a&nbsp; 2&nbsp; 5&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>b&nbsp; 4&nbsp;&nbsp; 6&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>c&nbsp;&nbsp; 6&nbsp;&nbsp; 7&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp; 8&nbsp;&nbsp; 3&nbsp; h </P></BODY></HTML> Tue, 28 Nov 2017 09:04:47 GMT https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383300#M8256 shraddha_g 2017-11-28T09:04:47Z Re: remove numeric columns from table https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383301#M8257 <HTML><HEAD></HEAD><BODY><P>fact table and dimension table structure only pk and fk are common&nbsp; rest separate dimension(characters) and numerical values in fact table</P><P>fact table dimesnion</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"> a 2 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a e</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp; b 4 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bf</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp;&nbsp; c 6 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cg</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp;&nbsp;&nbsp; d 8 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df</P></BODY></HTML> Tue, 28 Nov 2017 13:25:06 GMT https://community.qlik.com/t5/Integration-Extension-APIs/remove-numeric-columns-from-table/m-p/1383301#M8257 Anonymous 2017-11-28T13:25:06Z