Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Is there any way to export in another format than CSV or Tableau via the Data Warehouse ?

Avatar

Level 2

Hello all,

     I am currently experiencing difficulties in regards to exports I am doing via the Data Warehouse. Considering one of my dimension (clientID) is a string of over 15 characters, Excel automatically rounds off the figure (eg. shows as 1.55E+32 instead of the longer value).  Considering I am opening the CSV file once I receive the Adobe Analytics email, this dimension shows as a truncated number instead of the full string. If I was able to export the value as a text or export the file as a TXT, I could solve this problem.

Would anyone have a suggestion to prevent from the rounding up of my clientID to happen ?

Best

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

this is a problem of excel, i guess it doesn't change anything if you change to txt.

workaround: add a classification to your prop/evar with regex rule "*" and value "ID-$1". this should result in a new dimension with the same data, except there is a "ID-" before the number. if you export this new dimension (instead of the original ID) as csv, excel should think it is a string automatically

View solution in original post

3 Replies

Avatar

Community Advisor

import the csv in excel with "text string" for the desired column. if you are using the import wizard, select the desired row and mark as "string" (instead of "default"). this way, excel will see the values as text strings and you want see any truncated numbers.

or google for "excel import csv number truncate" to see more solutions ...

Avatar

Level 2

Thanks again for your response. Since we are sending the different stakeholders the file directly by email, we would like to avoid user to make data manipulation via the Import Wizard.  Your solution works but is there any chance we can potentially send the file in a .txt extension so that the end user do not need to change the column text format.

Avatar

Correct answer by
Community Advisor

this is a problem of excel, i guess it doesn't change anything if you change to txt.

workaround: add a classification to your prop/evar with regex rule "*" and value "ID-$1". this should result in a new dimension with the same data, except there is a "ID-" before the number. if you export this new dimension (instead of the original ID) as csv, excel should think it is a string automatically