topic 2 Colums from 1 Row in QlikView https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269255#M101003 <HTML><HEAD></HEAD><BODY><P>Anyone?</P></BODY></HTML> Thu, 09 Feb 2012 19:41:11 GMT pgalvezt 2012-02-09T19:41:11Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269252#M101000 <HTML><HEAD></HEAD><BODY><P>Im sorry Yes youre right its more complex</P></BODY></HTML> Thu, 09 Feb 2012 19:06:43 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269252#M101000 pgalvezt 2012-02-09T19:06:43Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269253#M101001 <HTML><HEAD></HEAD><BODY><P>If the case of the attached excel it would be a simple left(trim(Column1),10) and a right(trim(Column1),10), but in more complex cases the functions subfield(), index() and mid() are useful.</P><P></P><P>Karl</P></BODY></HTML> Thu, 09 Feb 2012 19:20:30 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269253#M101001 pover 2012-02-09T19:20:30Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269254#M101002 <HTML><HEAD></HEAD><BODY><P>I put another example Im sorry. I've attached the other example. Thanks!</P></BODY></HTML> Thu, 09 Feb 2012 19:28:56 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269254#M101002 pgalvezt 2012-02-09T19:28:56Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269255#M101003 <HTML><HEAD></HEAD><BODY><P>Anyone?</P></BODY></HTML> Thu, 09 Feb 2012 19:41:11 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269255#M101003 pgalvezt 2012-02-09T19:41:11Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269256#M101004 <HTML><HEAD></HEAD><BODY><P>I believe you edit the question...</P></BODY></HTML> Thu, 09 Feb 2012 19:43:25 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269256#M101004 2012-02-09T19:43:25Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269257#M101005 <HTML><HEAD></HEAD><BODY><P>I put another example. That is the reason <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 09 Feb 2012 19:49:33 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269257#M101005 pgalvezt 2012-02-09T19:49:33Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269258#M101006 <HTML><HEAD></HEAD><BODY><P>But what are we looking at in the excel file?</P><P>How do we identify the columns?</P></BODY></HTML> Thu, 09 Feb 2012 19:52:00 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269258#M101006 2012-02-09T19:52:00Z 2 Colums from 1 Row https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269259#M101007 <HTML><HEAD></HEAD><BODY><P>I don't understand the new excel.</P></BODY></HTML> Thu, 09 Feb 2012 20:50:26 GMT https://community.qlik.com/t5/QlikView/2-Colums-from-1-Row/m-p/269259#M101007 pover 2012-02-09T20:50:26Z