Expand my Community achievements bar.

SOLVED

Omniture Data Warehous FTP Output

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

4 Replies

Avatar

Level 2

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. 

Avatar

Employee

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

Avatar

Level 1

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

Avatar

Correct answer by
Employee

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