Omniture Data Warehous FTP Output

[kamlesh_khollam]

Hi,

Can anyone tell me how to format Omniture Data Warehouse FTP output i.e. Date Column formatting (as 'YYYY-MM-DD') and output column delimiter.

Regards,

Kamlesh

[darrynk23768843]

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. 

[TanmayMathur]

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

[kamlesh_khollam]

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

[TanmayMathur · Accepted solution]

Hi Kamlesh,

You can use Comma as a column delimiter, and after that select the date column and change the date format. 

Let me know if that works for you.

Regards,

TM