Data Warehouse - string value missing in CSV Format | Adobe Higher Education
Skip to main content
S
sudheer3
Level 2
January 19, 2023
Beantwortet

Data Warehouse - string value missing in CSV Format

  • January 19, 2023
  • 1 Antwort
  • 658 Ansichten

Hi,

 

Is there any way to get the string values to be added in Raw data report from Data warehouse report in a CSV format.

For ex: We need the variable value is 00005265. But in the CSV format instead of showing this(00005265) Value it is showing (5265) Value.

 

The value is coming perfectly in the website as well as reports. The issue is happening on Raw data reports from Data Warehouse request.

 

Let me know how can we solve this.

 

Thanks,

Sudheer.

 

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von nilotpal

Hi @sudheer3 ,


As I understand your questions, this essentially is the limitation of a CSV file reader apps in default view. We can however maintain the leading 0s in a CSV file.

Simply look for 'How can I keep leading zeros in CSV files?' on the internet and you should have handy resource docs for this use case. 

 

I came across this help doc and I then had zero succeeding issues with preceding zeros in the CSV file. 😜 See if it is helpful.




1 Antwort

nilotpal
Adobe Employee
nilotpalAdobe EmployeeAntwort
Adobe Employee
January 19, 2023

Hi @sudheer3 ,


As I understand your questions, this essentially is the limitation of a CSV file reader apps in default view. We can however maintain the leading 0s in a CSV file.

Simply look for 'How can I keep leading zeros in CSV files?' on the internet and you should have handy resource docs for this use case. 

 

I came across this help doc and I then had zero succeeding issues with preceding zeros in the CSV file. 😜 See if it is helpful.




    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...