6 Replies Latest reply: Oct 20, 2017 2:24 PM by Massimo Grossi RSS

    Question on how to put the JOIN Statment

    FELIPE HERNANDEZ

      I have a question regarding Qlik Sense on how to put the JOIN Statment.

       

      I would like to select on the File B only records that contains the File A 

      As you will see I have the same field on both Files (Field: Order).

       

       

       

      File A:

        LOAD "wo_nbr" as "Order",

           "wo_ord_date" as "Date";

        QL SELECT "wo_nbr",

           "wo_ord_date",

        ROM MFGPROD.PUB."wo_mstr" where "wo_nbr" like 'PS%' and "wo_status" = 'R';

       

      File B:

      LOAD "wod_nbr" as "Order",

      "wod_qty_req" as "Quantity";

        SQL SELECT "wod_nbr",

        "wod_lot",

        "wod_iss_date",

        "wod_part",

        ROM MFGPROD.PUB."wod_det" WHERE "wod_nbr" like 'PS%';

       

       

       

      I will appreciate your help.

       

      Regards