topic Re: How to append records based on field in QlikView https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145432#M374890 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY&amp;'_'&amp;ID AS ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SALES</P><P>FROM Location;</P><P></P><P>Mark</P></BODY></HTML> Mon, 08 Aug 2016 08:47:23 GMT Mark_Little 2016-08-08T08:47:23Z How to append records based on field https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145431#M374889 <HTML><HEAD></HEAD><BODY><P>Hi PFB</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="260" style="height: 165px; width: 268px;" width="268"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" width="64">COUNTRY</TD><TD class="xl63" width="64">SALES</TD></TR><TR><TD class="xl63" height="20">1</TD><TD class="xl63">us</TD><TD class="xl63">100</TD></TR><TR><TD class="xl63" height="20">2</TD><TD class="xl63">uk</TD><TD class="xl63">200</TD></TR><TR><TD class="xl63" height="20">3</TD><TD class="xl63">us</TD><TD class="xl63">300</TD></TR><TR><TD class="xl63" height="20">4</TD><TD class="xl63">ca</TD><TD class="xl63">400</TD></TR><TR><TD class="xl63" height="20">5</TD><TD class="xl63">us</TD><TD class="xl63">500</TD></TR><TR><TD class="xl63" height="20">6</TD><TD class="xl63">uk</TD><TD class="xl63">600</TD></TR><TR><TD class="xl63" height="20">7</TD><TD class="xl63">us</TD><TD class="xl63">700</TD></TR><TR><TD class="xl63" height="20">8</TD><TD class="xl63">ca</TD><TD class="xl63">800</TD></TR><TR><TD class="xl63" height="20">9</TD><TD class="xl63">us</TD><TD class="xl63"><P>900</P></TD></TR></TBODY></TABLE><P>in above sheet i have mentioned ID,COUNTRY,SALES my requirement is if ID related to US it should be display US_id like that i have some confusion how to write condition&nbsp; and expected output is </P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl65" height="20" width="64">ID</TD><TD class="xl65" width="64">COUNTRY</TD><TD class="xl65" width="64">SALES</TD></TR><TR><TD class="xl65" height="20">us_1</TD><TD class="xl65">us</TD><TD class="xl65">100</TD></TR><TR><TD class="xl65" height="20">uk_2</TD><TD class="xl65">uk</TD><TD class="xl65">200</TD></TR><TR><TD class="xl65" height="20">us_3</TD><TD class="xl65">us</TD><TD class="xl65">300</TD></TR><TR><TD class="xl65" height="20">ca_4</TD><TD class="xl65">ca</TD><TD class="xl65">400</TD></TR><TR><TD class="xl65" height="20">us_5</TD><TD class="xl65">us</TD><TD class="xl65">500</TD></TR><TR><TD class="xl65" height="20">uk_6</TD><TD class="xl65">uk</TD><TD class="xl65">600</TD></TR><TR><TD class="xl65" height="20">us_7</TD><TD class="xl65">us</TD><TD class="xl65">700</TD></TR><TR><TD class="xl65" height="20">ca_8</TD><TD class="xl65">ca</TD><TD class="xl65">800</TD></TR><TR><TD class="xl65" height="20">us_9</TD><TD class="xl65">us</TD><TD class="xl65">900</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in Advance,</P></BODY></HTML> Mon, 08 Aug 2016 08:42:28 GMT https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145431#M374889 vinod2086 2016-08-08T08:42:28Z Re: How to append records based on field https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145432#M374890 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY&amp;'_'&amp;ID AS ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SALES</P><P>FROM Location;</P><P></P><P>Mark</P></BODY></HTML> Mon, 08 Aug 2016 08:47:23 GMT https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145432#M374890 Mark_Little 2016-08-08T08:47:23Z Re: How to append records based on field https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145433#M374891 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COUNTRY</SPAN>&amp;'_'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ID </SPAN>as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ID,</SPAN></P><P></P><P>Regards,</P><P>Mayank</P></BODY></HTML> Mon, 08 Aug 2016 08:49:24 GMT https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145433#M374891 mayankraoka 2016-08-08T08:49:24Z Re: How to append records based on field https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145434#M374892 <HTML><HEAD></HEAD><BODY><P>Do like this:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14706461633897248 jive_text_macro" jivemacro_uid="_14706461633897248"> <P>LOAD ID &amp; '_' &amp; COUNTRY as ID,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; SALES</P> <P>FROM</P> <P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2051" data-containertype="14" data-objectid="228216" data-objecttype="1" href="https://community.qlik.com/thread/228216">https://community.qlik.com/thread/228216</A><SPAN>]</SPAN></P> <P>(html, codepage is 1257, embedded labels, table is @1);</P> </PRE><P></P><P>The result would be like:</P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133898_Screenshot_1.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 08 Aug 2016 08:49:40 GMT https://community.qlik.com/t5/QlikView/How-to-append-records-based-on-field/m-p/1145434#M374892 MindaugasBacius 2016-08-08T08:49:40Z