0 Replies Latest reply: Oct 17, 2017 6:07 AM by Carotenuto Massimiliano RSS

    Kitting info

    Carotenuto Massimiliano

      Hello All,

       

      Thanks in advance for tthe support, i have a problem, i have to reproduce the function that i have in SQL in QLiksense someone could help me?

       

      Below the sql formule:

       

      SELECT COALESCE(k.linked_request_unit_id,k.request_unit_id) AS request_unit_id

      , CASE

      WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NULL then 'MASTER'

      WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NOT NULL then 'PART KIT'

      ELSE N'#' END AS [Master/Part]

        INTO #kitting_product

        FROM ing_kitting_product k

       

      thanks again

       

      Massimiliano