Hot answers tagged

3

Columns that contain space or use reserved SQL keyword needs to be wrapped in the square brackets so that the query knows it is a single Column. Use [Communication Key], and all should work.


1

You have to specify if you only want unique opens -- otherwise, _Opens reflects every open of an email by a subscriber: select o.SubscriberKey as 'EMAIL' , o.eventdate as 'Data_abertura' , o.jobid , o.ListID , o.BatchID , o.TriggererSendDefinitionObjectID , j.EmailName , j.EmailSubject , j.DeliveredTime , j2.JourneyName , j2.VersionNumber , j2....


1

You would need to find the foreign key(s) that correctly matches each row in the two DEs for this task. As @MateuszDabrowski stated, INSERT INTO, etc. are not acceptable, only queries via SELECT. To this extent you need to use a JOIN in your SQL Query to accomplish this. To that extent, you would want something like the following: SELECT a.primarykey, b.[...


1

Marketing Cloud doesn't support INSERT INTO, just standard SELECT. Use SELECT with JOIN in a Query Activity of the Automation Studio and output to the desired Data Extension.


1

As you want to use a query for that, you can do it with a simple join: SELECT de2.EmailName , de2.TotalSent , de2.UniqueClicks , de2.UniqueOpens , de1.SourceCode FROM DataExtension2 AS de2 LEFT JOIN DataExtension1 AS de1 ON de1.EmailName = de2.EmailName However, I wouldn't recommend doing it that way, as it would require ...


Only top voted, non community-wiki answers of a minimum length are eligible