Export Primary Key from a broadLog Schema

Avatar

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile
johnf48867289
Level 2

10-05-2019

I need to export the primary key (broadlogid) from the broadLogRtEvent schema for a daily log file extract.

In the Extract file activity there's no option to export the primary key (see attached image).

Adobe's online documentation states "It is not possible to export unique identifiers (primary keys) of log resources." However, there must be a way around this using a different approach.

Does anyone have any ideas on how to export the primary key from an Adobe out-of-the-box schema?

Thank you,

John

ACS - No Primary Key Available for Extract File.PNG

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

29-05-2019

You can try to add a selection on  @PKey  on either the query or an enrichment

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

03-06-2019

It worked.

Thanks.