Data warehouse export data

[Carolina_2Va]

Dear Community,

When creating a request with granularity, in Adobe Analytics Data Warehouse, we get an output file with a "Date" column which includes a comma to split the year. As we are converting the .csv file, using comma as its delimiter, the column split is not working fine. Is there a way to adjust this before the export? Take the example below:

Thank you in advance,

Carolina

[eric-hansen-wgu · Accepted solution]

You might want to try rebuilding the Data Warehouse request, because when I tested it, the dates were properly escaped with quotation marks ("):

"Date","Visits"
"November 10, 2021",193651
"November 11, 2021",203375
"November 12, 2021",196598
"November 13, 2021",185707
"November 14, 2021",183288
"November 15, 2021",182520
"November 16, 2021",184130

Your CSV file looks incorrect because the second column where the Unique Visitors number is contained has quotation marks when it doesn't need them.