5 Replies Latest reply: Sep 4, 2018 11:42 AM by Andrey Krylov RSS

    qlik sql script

    Mallika Mhapankar

      Hi guys,

      i want to join a table (whose data I extracted from SAP HANA) to itself . The table is named tableone

      A1.left: tableone

      A2.right: tableone

       

      I would like to join it to itself, only where A2."ProductStatus" is not 'To archive'

      and join on A1."Product"=A2."SystemTrigger"

       

      Also, I want to be able to name "PRODUCTDESCRIPTION" column as "System Description"