Dimesion values containing commas and Data Warehouse extracts | Community
Skip to main content
B
Ben_Step
Level 3
January 13, 2022
Solved

Dimesion values containing commas and Data Warehouse extracts

  • January 13, 2022
  • 1 reply
  • 811 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by aman_gup98

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

 

1 reply

A
aman_gup98Accepted solution
Level 2
January 18, 2022

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

 

Terms & ConditionsAccessibility statement

Loading footer...