topic Cartesian product from sql table and excel file in QlikView https://community.qlik.com/t5/QlikView/Cartesian-product-from-sql-table-and-excel-file/m-p/1434769#M817135 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i need to do a cartesian product from an excel file and from a sql table.</P><P></P><P>¿could you show me how can it be done or where can i see it how can it be done?</P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Cartesian product from sql table and excel file https://community.qlik.com/t5/QlikView/Cartesian-product-from-sql-table-and-excel-file/m-p/1434769#M817135 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i need to do a cartesian product from an excel file and from a sql table.</P><P></P><P>¿could you show me how can it be done or where can i see it how can it be done?</P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cartesian-product-from-sql-table-and-excel-file/m-p/1434769#M817135 Anonymous 2020-11-25T16:16:04Z Re: Cartesian product from sql table and excel file https://community.qlik.com/t5/QlikView/Cartesian-product-from-sql-table-and-excel-file/m-p/1434770#M817136 <HTML><HEAD></HEAD><BODY><P>Hi Pablo,</P><P>To obtain the cartesian product of two table then perform an outer join. If you load your data from SQL into table A then</P><P></P><P>Outer Join([Table A)</P><P>Load</P><P>.</P><P>.</P><P>.</P><P>From .....xls</P><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Tue, 05 Sep 2017 09:22:05 GMT https://community.qlik.com/t5/QlikView/Cartesian-product-from-sql-table-and-excel-file/m-p/1434770#M817136 effinty2112 2017-09-05T09:22:05Z