How to Join Tables in ACC

Question

Hi,

I would like to join broadlog table and tracking log table.

Something like this in SQL world:

select

a.col1,

b.col2,

from table1 as a

left outer join table2 as b

on a.id=b.id

I see there is a built-in linkage between Broadlog table and trackinglog table, but I would like to create a new table that has characteristics of LOJ

Amit_Shinde · Accepted Answer

Hi @hule

Not sure why you want to create the custom table for broadLog & TrackingLog. We can achieve this in the workflow using the steps defined below.

1. Query on broadLogRcp table in the first query activity to select the filtered data
2. Next enrichment activity, create a link(Add data>A link)
3. Select Define a link whose target does not necessarily exist in the base & link target will be trackingLogRcp
4. Give the join condition as @id(broadLogRcp)=[@broadLog-id](trackingLogRcp)
5. After that go to Edit additional data from the enrichment main tab & add columns you wanted from the trackingLogRcp table

Thanks,

Amit

Sukrity_Wadhwa · Answer

Hi @hule,Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.Thanks!

Sign up

Login with SSO

Login to the community

Login with SSO