Solved

Data profiling - set attribute type

  • 31 March 2022
  • 2 replies
  • 56 views

  • New Participant
  • 1 reply

Hi, 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

icon

Best answer by Maksim Zhelyazkov 7 April 2022, 14:02

View original

2 replies

Badge

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

OK, thank you for your reply!

Reply