Defining delimiter for csv files in DWH reports?

Question

Hi, I know I can define the settings for the delimiter under Components>Report Settings. Unfortunately this doesn't affect reports generated by DWH. This is especially annoying since the default delimiter is a comma which is annoying because it conflicts with the date format.

TanmayMathur · Accepted Answer

Hi,It is not possible to change the delimiter in the DWH reports. But you can get in touch with Engineering Services through your account manager and have a custom solution in place. However, that would be at an additional cost.Thanks!TM

Harsh_Kabra · Answer

**All the views given here are my personal and has no relation or doesn't reflect views of my employer.

Hi Alev,

It wouldn't be an easy and cost effective way to get the default delimiter changed for DWH reports. This leaves us with 2 options:

1. Look at the possibility to get the date format changed. Don't miss the 2nd and my recommended option

2. You must be using DWH reports for a specific purpose, try setting up Scheduled reports (or Data Extract) for it. If this doesn't serve the purpose and you are looking to get some raw data, ask Adobe Client Care to setup the Data Feeds(similar to DWH reports).

Do like the post should you find useful by clicking on the "Heart Icon" and move this to "Solved" status for the benefit of other users of the forum.

Hope this helps!

Regards,

Harsh Kabra | Adobe Certified Expert: Digital Analytics® & SiteCatalyst Implementation & Reporting®

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded