Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Dimesion values containing commas and Data Warehouse extracts

Ben_Step
Level 2
Level 2

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
aman_gup98
Level 2
Level 2

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

aman_gup98_0-1642519812912.png