Adobe Campaign Classic - Data Extraction

Avatar

Avatar

dusandj

Avatar

dusandj

dusandj

30-07-2019

Hi,

I've created a workflow which has Query Activity, followed by Data Extraction and finally a File transfer.
Everything works fine, however when I try to configure the Data Extraction activity I'm getting some weird results.

I've configured it to export the data from Query activity into the CSV file and I've selected the output columns which I need in that file, but the exported file has more columns (actually columns are being copied in additional columns as duplicates).
It looks like this:

I need to export open events for all deliveries for each recipient, but those events get grouped by recipient and I need the new event to be in the next row, not duplicated in the column.
Is it possible to configure this properly?

P.S. If needed I can include screenshot.


Regards,
Dusan

View Entire Topic

Avatar

Avatar

AbdulZa

Avatar

AbdulZa

AbdulZa

30-07-2019

Hi,

Most likely you have a mapping issue in either the Query activity node or the enrichment activity node due to the resolution levels (targeting dimension) of your query and the output. Review these nodes again and make the proper adjustment. Remember that the relationship is 1:M between recipients to open/click table.

Thanks.