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
