Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Dimesion values containing commas and Data Warehouse extracts

Avatar

Level 3

We have some dimensions in our data that contain commas. When we do a data warehouse extract, these columns are breaking the layout because the file is comma separated and the columns aren't enclosed in quotes.

 

Is there anyway to tell DW to add quotes round columns in the extract, or any way to extract in a format other than CSV?

1 Accepted Solution

Avatar

Correct answer by
Level 2

@Ben_Step You can extract data in Tableau format by selecting it from the Advanced options.

aman_gup98_0-1642519812912.png

 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

@Ben_Step You can extract data in Tableau format by selecting it from the Advanced options.

aman_gup98_0-1642519812912.png