topic Re: How to append text before the real data? in QlikView https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399798#M1151936 <HTML><HEAD></HEAD><BODY><P>Hi priya</P><P></P><P>how about</P><P></P><P>1 as 'xx1'</P><P>2 as 'xx2'</P><P></P><P>or</P><P></P><P>'xx' <SPAN style="color: #808080; font-size: 10pt;">+</SPAN><SPAN style="font-size: 10pt;"> 1</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">regards</SPAN></P><P><SPAN style="font-size: 10pt;">Petra</SPAN></P></BODY></HTML> Thu, 25 Apr 2013 09:39:55 GMT 2013-04-25T09:39:55Z How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399797#M1151935 <HTML><HEAD></HEAD><BODY><P>Hello Everybody,</P><P></P><P>I have data Say</P><P>Flight</P><P>1</P><P>2</P><P>3</P><P>4</P><P>5</P><P>10..I want to append text before this data like</P><P></P><P>Flight </P><P>XX1</P><P>XX2</P><P>XX3</P><P>XX4</P><P>XX5</P><P>XX6</P><P>XX10</P><P></P><P>Thank in advance...</P><P></P><P></P><P>Regards,</P><P>priya</P></BODY></HTML> Thu, 25 Apr 2013 09:36:35 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399797#M1151935 priyav24 2013-04-25T09:36:35Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399798#M1151936 <HTML><HEAD></HEAD><BODY><P>Hi priya</P><P></P><P>how about</P><P></P><P>1 as 'xx1'</P><P>2 as 'xx2'</P><P></P><P>or</P><P></P><P>'xx' <SPAN style="color: #808080; font-size: 10pt;">+</SPAN><SPAN style="font-size: 10pt;"> 1</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">regards</SPAN></P><P><SPAN style="font-size: 10pt;">Petra</SPAN></P></BODY></HTML> Thu, 25 Apr 2013 09:39:55 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399798#M1151936 2013-04-25T09:39:55Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399799#M1151937 <HTML><HEAD></HEAD><BODY><P>load </P><P>Flight &amp; Flight1 as new_Flight </P><P></P><P>or</P><P></P><P>a:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Flight</P><P>&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp;&nbsp; 3</P><P>&nbsp;&nbsp;&nbsp; 4</P><P>&nbsp;&nbsp;&nbsp; 5</P><P>&nbsp;&nbsp;&nbsp; 10</P><P>];</P><P></P><P></P><P>LOAD 'xx' &amp; Flight as n Resident a;</P></BODY></HTML> Thu, 25 Apr 2013 09:45:42 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399799#M1151937 2013-04-25T09:45:42Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399800#M1151938 <HTML><HEAD></HEAD><BODY><P>a:</P><P>LOAD * Inline [</P><P>Flight</P><P>1</P><P>2</P><P>3</P><P>4</P><P>5</P><P>];</P><P>NoConcatenate</P><P>LOAD 'XX' &amp; Flight as Flight</P><P>Resident a;</P><P>DROP Table a;</P></BODY></HTML> Thu, 25 Apr 2013 09:49:25 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399800#M1151938 er_mohit 2013-04-25T09:49:25Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399801#M1151939 <HTML><HEAD></HEAD><BODY><P>I wanted to do something in expression</P></BODY></HTML> Thu, 25 Apr 2013 10:05:16 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399801#M1151939 priyav24 2013-04-25T10:05:16Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399802#M1151940 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">a:</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">LOAD * Inline [</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Flight</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">1</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">2</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">3</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">4</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">5</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">];</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">take dimension Flight</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">add expression</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">'XX' &amp; Flight</P></BODY></HTML> Thu, 25 Apr 2013 10:10:34 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399802#M1151940 er_mohit 2013-04-25T10:10:34Z Re: How to append text before the real data? https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399803#M1151941 <HTML><HEAD></HEAD><BODY><P>if it is correct as per your requirement then you have to mark it as correct answer to closed this thread. So that it might be helpful for other developer</P><P></P><P>Regards</P><P>Mohit</P></BODY></HTML> Sat, 27 Apr 2013 08:52:33 GMT https://community.qlik.com/t5/QlikView/How-to-append-text-before-the-real-data/m-p/399803#M1151941 er_mohit 2013-04-27T08:52:33Z