topic Straight table Comparison with alternate State in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Straight-table-Comparison-with-alternate-State/m-p/1699143#M5121 <P>Hi,</P><P>Table with data in below format&nbsp;</P><TABLE width="349"><TBODY><TR><TD width="64">Yr</TD><TD width="78">Base 5</TD><TD width="64">Part</TD><TD width="64">Plt</TD><TD width="79">Cost</TD></TR><TR><TD>2020</TD><TD>12345</TD><TD>12345AA</TD><TD>P1</TD><TD>100</TD></TR><TR><TD>2020</TD><TD>56789</TD><TD>56789AA</TD><TD>P1</TD><TD>50</TD></TR><TR><TD>2021</TD><TD>12345</TD><TD>12345AA</TD><TD>P1</TD><TD>110</TD></TR><TR><TD>2021</TD><TD>12345</TD><TD>12345AB</TD><TD>P1</TD><TD>110</TD></TR><TR><TD>2021</TD><TD>56789</TD><TD>56789AB</TD><TD>P1</TD><TD>55</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Created Filter 1 with Alt_State1 for Yr 2020 Selection(Prev Yr) and Filter with Alt_State2 for Yr 2021 Selection(Curr Yr) and I am looking for the result in straight table as below</P><TABLE width="477"><TBODY><TR><TD width="64">Base 5</TD><TD width="78">Plt</TD><TD width="64">Prev Yr Part</TD><TD width="64">Curr Yr Part</TD><TD width="79">Prev Yr Cost</TD><TD width="64">Curr Yr Cost</TD><TD width="64">Diff</TD></TR><TR><TD>12345</TD><TD>P1</TD><TD>12345AA</TD><TD>12345AA</TD><TD>100</TD><TD>110</TD><TD>10</TD></TR><TR><TD>12345</TD><TD>P1</TD><TD>12345AA</TD><TD>12345AB</TD><TD>100</TD><TD>110</TD><TD>10</TD></TR><TR><TD>56789</TD><TD>P1</TD><TD>56789AA</TD><TD>56789AB</TD><TD>50</TD><TD>55</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The part 12345AA is once in Yr 2020, but the Base 5 for both yr are same, I need to repeat twice to match to both the parts 12345AA and 12345AB from Curr Yr.</P><P>&nbsp;</P> Fri, 10 Dec 2021 20:26:56 GMT g_santhosh86 2021-12-10T20:26:56Z Straight table Comparison with alternate State https://community.qlik.com/t5/Connectivity-Data-Prep/Straight-table-Comparison-with-alternate-State/m-p/1699143#M5121 <P>Hi,</P><P>Table with data in below format&nbsp;</P><TABLE width="349"><TBODY><TR><TD width="64">Yr</TD><TD width="78">Base 5</TD><TD width="64">Part</TD><TD width="64">Plt</TD><TD width="79">Cost</TD></TR><TR><TD>2020</TD><TD>12345</TD><TD>12345AA</TD><TD>P1</TD><TD>100</TD></TR><TR><TD>2020</TD><TD>56789</TD><TD>56789AA</TD><TD>P1</TD><TD>50</TD></TR><TR><TD>2021</TD><TD>12345</TD><TD>12345AA</TD><TD>P1</TD><TD>110</TD></TR><TR><TD>2021</TD><TD>12345</TD><TD>12345AB</TD><TD>P1</TD><TD>110</TD></TR><TR><TD>2021</TD><TD>56789</TD><TD>56789AB</TD><TD>P1</TD><TD>55</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Created Filter 1 with Alt_State1 for Yr 2020 Selection(Prev Yr) and Filter with Alt_State2 for Yr 2021 Selection(Curr Yr) and I am looking for the result in straight table as below</P><TABLE width="477"><TBODY><TR><TD width="64">Base 5</TD><TD width="78">Plt</TD><TD width="64">Prev Yr Part</TD><TD width="64">Curr Yr Part</TD><TD width="79">Prev Yr Cost</TD><TD width="64">Curr Yr Cost</TD><TD width="64">Diff</TD></TR><TR><TD>12345</TD><TD>P1</TD><TD>12345AA</TD><TD>12345AA</TD><TD>100</TD><TD>110</TD><TD>10</TD></TR><TR><TD>12345</TD><TD>P1</TD><TD>12345AA</TD><TD>12345AB</TD><TD>100</TD><TD>110</TD><TD>10</TD></TR><TR><TD>56789</TD><TD>P1</TD><TD>56789AA</TD><TD>56789AB</TD><TD>50</TD><TD>55</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The part 12345AA is once in Yr 2020, but the Base 5 for both yr are same, I need to repeat twice to match to both the parts 12345AA and 12345AB from Curr Yr.</P><P>&nbsp;</P> Fri, 10 Dec 2021 20:26:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Straight-table-Comparison-with-alternate-State/m-p/1699143#M5121 g_santhosh86 2021-12-10T20:26:56Z