<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to Merge Two Column in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-Merge-Two-Column/m-p/1967313#M1220410</link>
    <description>&lt;P&gt;Your sample output doesn't match your description, but I'll answer the description and I'm sure you can adapt it if necessary.&lt;/P&gt;
&lt;P&gt;Load Months, Month2 as Month1&lt;/P&gt;
&lt;P&gt;From YourTable;&lt;/P&gt;
&lt;P&gt;Concatenate&lt;/P&gt;
&lt;P&gt;Load Month1 as Months, Month3 as Month1&lt;/P&gt;
&lt;P&gt;From YourTable;&lt;/P&gt;</description>
    <pubDate>Wed, 10 Aug 2022 18:41:27 GMT</pubDate>
    <dc:creator>Or</dc:creator>
    <dc:date>2022-08-10T18:41:27Z</dc:date>
    <item>
      <title>How to Merge Two Column</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-Merge-Two-Column/m-p/1967301#M1220409</link>
      <description>&lt;TABLE style="border-collapse: collapse; width: 192pt;" border="0" width="256" cellspacing="0" cellpadding="0"&gt;
&lt;TBODY&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD width="64" height="20" style="height: 15.0pt; width: 48pt;"&gt;Months&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;Month1&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;month2&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;month3&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Jan-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Feb-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl63" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl63"&gt;Mar-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;I want to Merge 1) Months and Month2 in one column ,2) Month1 and Month 3 in One column like Final Output should be like that&amp;nbsp;&lt;/P&gt;
&lt;TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"&gt;
&lt;TBODY&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD width="64" height="20" style="height: 15.0pt; width: 48pt;"&gt;Months&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;Month1&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Jan-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Feb-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Feb-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Feb-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-22&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Mar-22&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Jan-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Feb-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Feb-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Feb-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Jan-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Feb-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 15.0pt;"&gt;
&lt;TD height="20" align="right" class="xl65" style="height: 15.0pt;"&gt;Mar-21&lt;/TD&gt;
&lt;TD align="right" class="xl65"&gt;Mar-21&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;</description>
      <pubDate>Wed, 10 Aug 2022 18:29:07 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-Merge-Two-Column/m-p/1967301#M1220409</guid>
      <dc:creator>Sharad02</dc:creator>
      <dc:date>2022-08-10T18:29:07Z</dc:date>
    </item>
    <item>
      <title>Re: How to Merge Two Column</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-Merge-Two-Column/m-p/1967313#M1220410</link>
      <description>&lt;P&gt;Your sample output doesn't match your description, but I'll answer the description and I'm sure you can adapt it if necessary.&lt;/P&gt;
&lt;P&gt;Load Months, Month2 as Month1&lt;/P&gt;
&lt;P&gt;From YourTable;&lt;/P&gt;
&lt;P&gt;Concatenate&lt;/P&gt;
&lt;P&gt;Load Month1 as Months, Month3 as Month1&lt;/P&gt;
&lt;P&gt;From YourTable;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Aug 2022 18:41:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-Merge-Two-Column/m-p/1967313#M1220410</guid>
      <dc:creator>Or</dc:creator>
      <dc:date>2022-08-10T18:41:27Z</dc:date>
    </item>
  </channel>
</rss>

