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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

DataSource only insert rows that has a match on transaction ID

M_Schoenmakers
Level 1
Level 1

We would like to setup a DataSource import using transactionID to import offline transaction into a reportsuite.

But the import file also contains records of transaction on products that belong to a different business unit which uses their own reportsuite.

Therefore we would like to import ONLY those rules from the file that have an transactionid that is also recorded during a visit in the reportsuite.

Is this possible directly from within Adobe Analytics?


Or is the only option to build a script that first retrieves all transactionid values from Adobe using the API and filters the original import file based on these before uploading it to the data source import?

Glad to hear what's possible

1 Accepted Solution
Gigazelle
Correct answer by
Employee
Employee

This most definitely isn't possible using Analytics alone. Adobe takes all the values in the file and attempts to process them, so you're going to get everything if you upload the file as-is.

If you're able to sanitize the file yourself using an automated process, that could work. Adobe also offers professional services that could certainly help establish an ideal workflow for you. If you'd like to pursue that route, you'd want to get in touch with your account manager.

View solution in original post

0 Replies
Gigazelle
Correct answer by
Employee
Employee

This most definitely isn't possible using Analytics alone. Adobe takes all the values in the file and attempts to process them, so you're going to get everything if you upload the file as-is.

If you're able to sanitize the file yourself using an automated process, that could work. Adobe also offers professional services that could certainly help establish an ideal workflow for you. If you'd like to pursue that route, you'd want to get in touch with your account manager.

View solution in original post