Avatar

Correct answer by
Level 3

Hi @gnals12 

 

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

View solution in original post