https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829638#M491 <P>there alaways two distinct value(b,c) in f2. in the final column in places of all b value there will be c value and vise versa.</P><P>&nbsp;</P> Thu, 19 Aug 2021 07:11:11 GMT Ratmadeep 2021-08-19T07:11:11Z https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829632#M489 <P>f1 f2<BR />a b<BR />a b<BR />a c<BR />a c<BR />a c</P><P>&nbsp;</P><P>Final output</P><P>&nbsp;</P><P>f1 f2 f3<BR />a b c<BR />a b c<BR />a c b<BR />a c b<BR />a c b</P> Thu, 19 Aug 2021 06:33:56 GMT https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829632#M489 Ratmadeep 2021-08-19T06:33:56Z https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829633#M490 <P>What is the logic to follow ?</P><P>&nbsp;</P> Thu, 19 Aug 2021 07:01:59 GMT https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829633#M490 Lisa_P 2021-08-19T07:01:59Z https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829638#M491 <P>there alaways two distinct value(b,c) in f2. in the final column in places of all b value there will be c value and vise versa.</P><P>&nbsp;</P> Thu, 19 Aug 2021 07:11:11 GMT https://community.qlik.com/t5/Search-the-Community/Data-interchange/m-p/1829638#M491 Ratmadeep 2021-08-19T07:11:11Z