SQL statement in qliksense giving an error

abc_18 — Thu, 13 Jun 2019 12:58:53 GMT

Hi,

I am trying to write below expression in qliksense itself, but it's throwing an error:-

[Parent]:

SELECT

a.code_marketing_campaign
,b.[BusinessUnit__c] as 'Parent Campaign BU'
,b.[CurrencyIsoCode] as ' Parent Campaign Currency Code'
,b.[Description] as 'Parent Campaign Description'
,b.[EndDate] as 'Parent Campaign End Date'
,b.skey_marketing_campaign as skey_campaign_parent
,b.[IsActive] as 'Parent Campaign Active flag'
,b.name_marketing_campaign as 'Parent Campaign Name'
,b.[Region__c] as 'Parent Campaign Region'
,b.[StartDate] as 'Parent Campaign Start Date'
,b.[Status] as 'Parent Campaign Status'
,b.category_marketing_campaign as 'Parent Campaign Type'

from (select distinct code_marketing_campaign from [WH_ID_EMEA].[dwh].[marketing_campaign]) a
inner join [WH_ID_EMEA].[dwh].[marketing_campaign] b
on a.code_marketing_campaign=b.bkey_marketing_campaign

group by
a.code_marketing_campaign
,b.[BusinessUnit__c]
,b.[CurrencyIsoCode]
,b.[Description]
,b.[EndDate]
,b.skey_marketing_campaign
,b.[IsActive]
,b.name_marketing_campaign
,b.[Region__c]
,b.[StartDate]
,b.[Status]
,b.category_marketing_campaign ;

Can someone plesae suggest what is missing?

Regards

topic SQL statement in qliksense giving an error in App Development

SQL statement in qliksense giving an error