Kitting info

[#1]

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