https://community.qlik.com/t5/App-Development/generic-load/m-p/1652688#M48745 <P>Hello,</P><P>I have an .sql table that looks like the one in attachment.</P><P>I want to extract one item from one column to build a new table.</P><P>in the example e.g. i want to sum the values of product A, for those contracts who also have a product D with a value above 30. So i would need a separate column or table with product D.</P><P>I think I have to do this with generic load, but i did not succeed in writing the right script to do this.&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Fri, 29 Nov 2019 13:03:12 GMT Essevee 2019-11-29T13:03:12Z https://community.qlik.com/t5/App-Development/generic-load/m-p/1652688#M48745 <P>Hello,</P><P>I have an .sql table that looks like the one in attachment.</P><P>I want to extract one item from one column to build a new table.</P><P>in the example e.g. i want to sum the values of product A, for those contracts who also have a product D with a value above 30. So i would need a separate column or table with product D.</P><P>I think I have to do this with generic load, but i did not succeed in writing the right script to do this.&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Fri, 29 Nov 2019 13:03:12 GMT https://community.qlik.com/t5/App-Development/generic-load/m-p/1652688#M48745 Essevee 2019-11-29T13:03:12Z https://community.qlik.com/t5/App-Development/generic-load/m-p/1652697#M48747 <P>Can you not use where clause instead of generic load and create separate tables.&nbsp;</P><P>&nbsp;</P><P>Thanks,</P> Fri, 29 Nov 2019 13:25:48 GMT https://community.qlik.com/t5/App-Development/generic-load/m-p/1652697#M48747 patilamay 2019-11-29T13:25:48Z