Omniture Data Warehous FTP Output

Hi Kamlesh,

I think the answer you are looking for is: You can't change the format of fields for output in a DataWarehouse report, you can only select the items, and they will be output in the format that Adobe uses. You will have to change the format once you receive the file and use it, or, if you are an admin, you can change it in the Company Settings -> Preferences by selecting the "Use ISO 8601 Date format for CSV (2015-06-30)", but this will affect everyone's extracts.

You can only use a comma delimiter for csv files as there is no choice for a different delimiter. 

Hi Kamlesh,

Thanks for reaching out!

Could you elaborate some more on how is your data arranged and how you want to format your it? It would be great if you could post a screenshot.

Regards,

TM

Thank you Tanmay for Response.

Current Output:

"May 1, 2015","0","abcd",1,0,0,0,0.00
"May 1, 2015","0","fydss",1,1,0,0,0.00
"May 1, 2015","0","abdkjsahf17267",1,0,0,0,0.00

Expected Output:

2015-05-01,0,abcd,1,0,0,0,0.00
2015-05-01,0,fydss,1,1,0,0,0.00
2015-05-01,0,abdkjsahf17267,1,0,0,0,0.00

Regards,

Kamlesh