Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!

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 Reply

Avatar

Level 2

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

aman_gup98_0-1642519812912.png