Hi All,
While I am saving the CSV format I am missing all the leading zeros added to the Data attributes, Since the data is huge I am using CSV format,
Kindly help as I tried to convert V_String to String using Formulae tool its not helping out to save the data with leading zeros
For Ex Input file has field records like
00000000012
00000001111
00000000001
While saving in CSV output file I am getting like
12
1111
1
Kindly help for CSV format.
Solved! Go to Solution.
@Ram_RK - are you saying when you open the file in Notepad that you see the leading zeros? Again - not an Alteryx issue here - but if you are for some insane reason going to post process your csvs in excel and check for accuracy in excel which you know auto converts junk - prepend an apostrophe in your workflow.
If you have an issue with Alteryx not producing the leading zeros - upload some samples - if not follow @cjaneczko 's instructions. You don't have a data issue - you have an excel/enduser issue.
Let me be clear - from a data ingestion standpoint 0000005558 and '0000005558 are not the same. if you ingest your data downstream in something real (ie excel is not real) you will screw up your ingestion system if you add the apostrophe's natively to your .csv files. if you know you are processing csvs of over 1mm records why would you check this in Excel? Ignore it. Load it in Polars locally - and see if you get the leading 0s.
thanks for the details. @cjaneczko I will ensure the same.