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