topic How can I use a intervalmatch to create a mapping table for all common or uncommon value in QlikView https://community.qlik.com/t5/QlikView/How-can-I-use-a-intervalmatch-to-create-a-mapping-table-for-all/m-p/238727#M89521 <HTML><HEAD></HEAD><BODY><P>I don't quite understand the question. Do you wish to see all values (1,2,3,4,5)? Then you may use JOIN. Otherwise you have repeated same data as in col1.</P><P>Peter</P></BODY></HTML> Sun, 15 Nov 2009 02:04:33 GMT prieper 2009-11-15T02:04:33Z How can I use a intervalmatch to create a mapping table for all common or uncommon value https://community.qlik.com/t5/QlikView/How-can-I-use-a-intervalmatch-to-create-a-mapping-table-for-all/m-p/238726#M89520 <HTML><HEAD></HEAD><BODY><P>table 1:</P><P>col1:</P><P>Value1,</P><P>value2,</P><P>value3</P><P>value5</P><P>....</P><P></P><P>col2:</P><P>value2</P><P>value3</P><P>value4</P><P>....</P><P></P><P>final mapping table should have all of them.</P><P>value1,</P><P>value2</P><P>value3</P><P>value5</P><P>Can you advise?</P></BODY></HTML> Thu, 12 Nov 2009 04:49:58 GMT https://community.qlik.com/t5/QlikView/How-can-I-use-a-intervalmatch-to-create-a-mapping-table-for-all/m-p/238726#M89520 2009-11-12T04:49:58Z How can I use a intervalmatch to create a mapping table for all common or uncommon value https://community.qlik.com/t5/QlikView/How-can-I-use-a-intervalmatch-to-create-a-mapping-table-for-all/m-p/238727#M89521 <HTML><HEAD></HEAD><BODY><P>I don't quite understand the question. Do you wish to see all values (1,2,3,4,5)? Then you may use JOIN. Otherwise you have repeated same data as in col1.</P><P>Peter</P></BODY></HTML> Sun, 15 Nov 2009 02:04:33 GMT https://community.qlik.com/t5/QlikView/How-can-I-use-a-intervalmatch-to-create-a-mapping-table-for-all/m-p/238727#M89521 prieper 2009-11-15T02:04:33Z