Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to Join Tables in ACC

Avatar

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile
gnals12
Level 1

23-04-2021

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

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

131 likes

Total Posts

804 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

131 likes

Total Posts

804 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
Sukrity_Wadhwa
Employee

05-05-2021

Hi @gnals12,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

Avatar

Avatar
Boost 3
Level 2
Amit_Shinde
Level 2

Likes

11 likes

Total Posts

17 posts

Correct Reply

7 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 3
Level 2
Amit_Shinde
Level 2

Likes

11 likes

Total Posts

17 posts

Correct Reply

7 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
Amit_Shinde
Level 2

23-04-2021

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