topic Re: Filter data from multiple source in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Filter-data-from-multiple-source/m-p/1448936#M3313 <HTML><HEAD></HEAD><BODY><P>If I understood correctly you want to only join both tables?</P><P>If so, its quite simple and possible to do in Qlik Sense Desktop.</P><P></P><P>1. Load the data from excel spreadsheet.</P><P>2. Create a connection to your database to load the db data.</P><P>3. See the common fields you wants to join both tables</P><P>4. Use the join statement to create a single table with all the fields you want.</P><P>5. Enjoy your new table <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>That's it mostly and since you didn't share enough information as to fields / tables you have or how you want to join them, here's a link of Qlik Help with some examples you can use to do so:</P><P><A href="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm" title="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm">Combining tables with Join and Keep ‒ Qlik Sense</A></P></BODY></HTML> Fri, 08 Dec 2017 14:14:04 GMT felipedl 2017-12-08T14:14:04Z Filter data from multiple source https://community.qlik.com/t5/Connectivity-Data-Prep/Filter-data-from-multiple-source/m-p/1448935#M3312 <HTML><HEAD></HEAD><BODY><P>I wish to filter data from postgre sql and excel data source. Scenario is:&nbsp; I have one user data in excel which i have loaded in qlik sense desktop version. Now connected to postgre sql db and loaded accounts data in qlik sense desktop version. Finally wants to create a new table with filtered data by joining these two data tables on some criteria. is it possible in qlik sense desktop version? Any help is appreciated.</P></BODY></HTML> Fri, 08 Dec 2017 05:41:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Filter-data-from-multiple-source/m-p/1448935#M3312 Anonymous 2017-12-08T05:41:23Z Re: Filter data from multiple source https://community.qlik.com/t5/Connectivity-Data-Prep/Filter-data-from-multiple-source/m-p/1448936#M3313 <HTML><HEAD></HEAD><BODY><P>If I understood correctly you want to only join both tables?</P><P>If so, its quite simple and possible to do in Qlik Sense Desktop.</P><P></P><P>1. Load the data from excel spreadsheet.</P><P>2. Create a connection to your database to load the db data.</P><P>3. See the common fields you wants to join both tables</P><P>4. Use the join statement to create a single table with all the fields you want.</P><P>5. Enjoy your new table <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>That's it mostly and since you didn't share enough information as to fields / tables you have or how you want to join them, here's a link of Qlik Help with some examples you can use to do so:</P><P><A href="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm" title="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm">Combining tables with Join and Keep ‒ Qlik Sense</A></P></BODY></HTML> Fri, 08 Dec 2017 14:14:04 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Filter-data-from-multiple-source/m-p/1448936#M3313 felipedl 2017-12-08T14:14:04Z