Export to csv trims zeroes at start of the number

Question & Answer
,
1

Hello Team,

My Text column has account_number values such as : 00003123213333, 00000343432132, etc

When I am exporting any visual with this column, the leading zeroes in the above account_number columns are being trimmed automatically.

How to avoid this unnecessary trimming?
Note: My column is of text datatype

Thanks in advance,
Ajinkya

2

You’re doing this to a csv or excel?

3

I am exporting to csv as I need some date columns too in my export

4

I would suggest creating a support case so AWS can look into it.

Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!