5. Select Order Lines for certain Products

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get the order lines for products in the hoodies product family, with an order line quantity of 20 or more https //www youtube com/watch?v=mwr202 shsa\&list=plfs7 dts7jwyhwe scy5z4qvgbh2ilspj\&index=5 or follow the steps below 1\ selection criteria on the selections overview screen, click on new to create a new selection drag data extension deselect demo products to the selected data extensions section drag data extension deselect demo order lines on top of deselect demo products in the selected data extensions section create the relationship products field id deselect demo products with matching deselect demo order lines order line field productid drag field product family to the selected filters section criteria equals value hoodies drag field quantity to the selected filters section criteria equal to or greater than value 20 2\ target definition hit the create data extension button, enter a name, eg product order lines, and press save select the following fields by either double clicking on them or dragging them to the section on the right orderid, sales price and amount from deselect demo order lines name from deselect demo products click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields orderid , sales price and amount from deselect demo order lines and name from deselect demo products the results table shows only order lines for products in the hoodies product family, with an order line quantity of 20 or more