https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414595#M94973 <P>How do i create another table which list out all possible combination (order does not matter) of supplier_name field in sets of 2 according to the event field?</P> <P>&nbsp;</P> <P>sample data:</P> <TABLE width="301"> <TBODY> <TR> <TD width="64">Category</TD> <TD width="134">event</TD> <TD width="103">supplier_name</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>ryde</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>long_john_silver</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>desired_output:</P> <TABLE width="411"> <TBODY> <TR> <TD width="62">Category</TD> <TD width="98">supplier_name</TD> <TD width="251">combination</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab, uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab, comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>uber, comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, ryde</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber, tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber, ryde</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>tada ryde</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, macdonald</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>five_fingers, long_john_silver</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 05 Feb 2024 05:48:06 GMT stormseekerx1 2024-02-05T05:48:06Z https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414595#M94973 <P>How do i create another table which list out all possible combination (order does not matter) of supplier_name field in sets of 2 according to the event field?</P> <P>&nbsp;</P> <P>sample data:</P> <TABLE width="301"> <TBODY> <TR> <TD width="64">Category</TD> <TD width="134">event</TD> <TD width="103">supplier_name</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>ryde</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>long_john_silver</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>desired_output:</P> <TABLE width="411"> <TBODY> <TR> <TD width="62">Category</TD> <TD width="98">supplier_name</TD> <TD width="251">combination</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab, uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>grab, comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_1</TD> <TD>uber, comfort</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, uber</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>grab, ryde</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber, tada</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>uber, ryde</TD> </TR> <TR> <TD>transport</TD> <TD>event_2</TD> <TD>tada ryde</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, macdonald</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>kfc, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, burger_king</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>macdonald, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king, five_fingers</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>burger_king, long_john_silver</TD> </TR> <TR> <TD>food</TD> <TD>event_3</TD> <TD>five_fingers, long_john_silver</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 05 Feb 2024 05:48:06 GMT https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414595#M94973 stormseekerx1 2024-02-05T05:48:06Z https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414601#M94975 <P>is this an interview question?</P> Mon, 05 Feb 2024 06:14:19 GMT https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414601#M94975 vinieme12 2024-02-05T06:14:19Z https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414632#M94979 <P>yea</P> <P>&nbsp;</P> Mon, 05 Feb 2024 07:41:46 GMT https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2414632#M94979 stormseekerx1 2024-02-05T07:41:46Z https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2415134#M95025 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/286570">@stormseekerx1</a>&nbsp;You have created a duplicate thread, please close this with reference of this <A href="https://community.qlik.com/t5/App-Development/How-do-i-create-all-possible-combination-order-does-not-matter/m-p/2414597#M94974" target="_blank">Solved: How do i create all possible combination (order do... - Qlik Community - 2414597</A></P> Tue, 06 Feb 2024 04:38:25 GMT https://community.qlik.com/t5/App-Development/How-do-i-create-another-table-which-list-out-all-possible/m-p/2415134#M95025 Anil_Babu_Samineni 2024-02-06T04:38:25Z