I have an .sql table that looks like the one in attachment.
I want to extract one item from one column to build a new table.
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.
I think I have to do this with generic load, but i did not succeed in writing the right script to do this.
