Import csv or txt, first line as column name failed

[LaurentS]

Hello,

When I import a csv or txt file, the first line is not recognized as column name, though in Python code it works perfectly. 

In DSS, after the import, I have :  

- In first line, I have col1, col2, etc

- In second line, the true name of the column as they are in the original csv/txt file

- Starting from third line, I have the rows

What is the solution to import a csv/txt with the appropriate col names ?  I could not figure it out.

Thanks and kindest regards

[AlexT · Accepted solution]

Hi Laurent,

You should be to adjust which line the true column names are on. Using "Skip First Lines" options. You can set that to 1 and user check Parse Next line as column headers.

If my .csv file is 

column1,column2
actual_name,other_name
some_value,some_value

This is what I would see : 

Let me know if that works for you. 

Thanks,

Alex

[LaurentS · Accepted solution]

I could figure out whete to see this option (preview after loading the file)

[AlexT · Accepted solution]

Hi Laurent,

You should be to adjust which line the true column names are on. Using "Skip First Lines" options. You can set that to 1 and user check Parse Next line as column headers.

If my .csv file is 

column1,column2
actual_name,other_name
some_value,some_value

This is what I would see : 

Let me know if that works for you. 

Thanks,

Alex

[LaurentS · Accepted solution]

I could figure out whete to see this option (preview after loading the file)

[AlexT · Accepted solution]

If you already have a dataset you can go settings and Format/Preview Tab. To get these options.

Additionally, you can reach this page when you create a dataset from a file there will be the Preview button once you import the file. 

Let me know if you still have issues finding these options. 

[prash_]

After Importing its working. Can we do the same in between the flow for any of the dataset.

[LaurentS]

Hi and thanks a lot.  I could figure out where to access to this view (preview after loading the file).  Kindest regards