Data Warehouse - string value missing in CSV Format | Community
Skip to main content
S
sudheer3
Level 2
January 19, 2023
Solved

Data Warehouse - string value missing in CSV Format

  • January 19, 2023
  • 1 reply
  • 658 views

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.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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 reply

nilotpal
Adobe Employee
nilotpalAdobe EmployeeAccepted solution
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.




    Terms & ConditionsAccessibility statement

    Loading footer...