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