Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!
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