Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

change the separators from commas (,) to semicolons (;) in datawarehouse export csv

Avatar

Level 1

Hello,

I sent a datawarehouse report in CSV format via SFTP. I received it, but the separator is a comma, and I want it to be a semicolon (;) instead. I don't see an option to change this. Could you please help me with this?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 2

@DouniaPal  Since Data export format is CSV i.e. Comma Separated Values that's why you will be receiving values as comma separated. There is no option available in Datawarehouse UI but you can once check with Client Care team if it is feasible from backend.

Avatar

Employee

Hey @DouniaPal Currently, I don't think is possible from the DW UI since the only exports are either CSV or Tableau which is mentioned in the documentation as well - https://experienceleague.adobe.com/en/docs/analytics/export/data-warehouse/dw-create-request/dw-requ...

Semi-colon isn't supported yet, but you can log this in the idea hub as a feature request.

Avatar

Level 2

@DouniaPal I agree with @AmanGu8 and @fhusain , there is no such feature yet introduced.