Hi All,
I'm trying to write Bag-ids (adress ids of the Netherlands) to an Excel or CSV file. However I'm unable to write it to these formats without destroying the data.
Source data example
Bag_id _
0735200000017598
1735200000017598
If I write it to CSV i'm losing the prefix 0 (while using varchar type).
If I write it to Excel the numbers without the prefix 0 are rounded (while using the string type)
See appendices.
The only fix i'm able to come up with is prefixing everything with " ' ". But that of course transforms the source data. This I don't want.
Does anyone have a solution for this?
I have added my test sample in the appendix aswell (e.g. source_data_v3)