HI all,
The following code works in SSMS but not in Qlik:
LIB CONNECT TO 'RALNHV (nhv_qlikadmin)';
PartInquiries:
SQL SELECT
[IssueDate]
,b.[PartNo]
,b.[Description]
,d.[SerialNo]
,d.[ReceivedQty]
,i.[TransactionType]
,g.[OrderNo]
,f.[TaskNo]
,c.[Priority]
,f.[TaskText]
,f.[CarriedOutText]
,f.[Description]
,f.[EstManHours]
,g.[PartNo] as AcModel
,g.[Reg]
,h.[Status]
-- Joining Date, PartNo, Priority and SerialNo:
FROM [RALNHV].[dbo].[sDemandPart] as a
LEFT JOIN [RALNHV].[dbo].[sPart] as b
ON a.[sPart_IDDemanded] = b.[ID]
lEFT JOIN [RALNHV].[dbo].[sPriority] as c
ON a.[sPriority_ID] = c.[ID]
LEFT JOIN [RALNHV].[dbo].[sOrderPartReceipt] as d
on a.[sOrderPartReceipt_ID] = d.[ID]
-- Joining the task Information:
LEFT JOIN [RALNHV].[dbo].[sDemand] as e
on a.[sDemand_ID] = e.[ID]
LEFT JOIN [RALNHV].[dbo].[sOrderTask] as f
on e.[sOrderTask_ID] = f.[ID]
--Joining the Order Information
LEFT JOIN [RALNHV].[dbo].[sOrder] as g
on f.[sOrder_ID] = g.[ID]
--Joining Status and TransactionType
LEFT JOIN [RALNHV].[dbo].[sDemandItemStatus] as h
on a.[sDemandItemStatus_IDLast] = h.[ID]
LEFT Join [RALNHV].[dbo].[sPartTransactionType] as i
on a.[sPartTransactionType_ID] = i.[ID]
-- To be checked what kind of WO can be left out of the table!
Where
a.IssueDate > Convert(datetime, '2016-01-01')
order by a.IssueDate
Error:
The following error occurred:
Field names must be unique within table
Any ideas? I don't see any actions not supported by Qlik...
regards
