+2Hi, I’ve just started data profiling with Ataccama One so please bear with me.
I have data with technical IDs (e.g. “000123456”, “009876543”,...) in a csv that I imported. The IDs are however interpreted as a number.
How exactly can I change the attribute type to text?
I have done so when importing the file:
but it seems to go to numbers nonetheless.
The original file has comma-separated values that are all between double quotes.
Thanks for any help!
edit: typo
Best answer by Maksim Zhelyazkov
Hello Semo,
Editing metadata works only on database tables and files from Server File System. If your csv file is being uploaded as a local file, you will not be able to change the data type.
We have an article called “Server File System as a Data Source” in our documentation, which explains how to configure it. Once you do so, you will be able to edit the data type of the files you upload from there.
Let me know if anything is unclear.
Regards,
Maksim
Hello Semo,
Editing metadata works only on database tables and files from Server File System. If your csv file is being uploaded as a local file, you will not be able to change the data type.
We have an article called “Server File System as a Data Source” in our documentation, which explains how to configure it. Once you do so, you will be able to edit the data type of the files you upload from there.
Let me know if anything is unclear.
Regards,
Maksim
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
