Append Columns in CSV

Pratap Singh shared this question 3 days ago
In Progress

Hi,

Just want to check about the feasibility of adding few more columns to the already created view from the CSV file.


Suppose I have created some reports and dashboard based on a CSV dataset,

now 2 more columns are required, what is the feasibility to do that?


I can only see Append and Modify options which don't allow to add extra columns.


Thanks

Pratap

Comments (1)

photo
1

Hi Pratap,

Thanks for contacting Yellowfin!

If you'd like to add some columns to a CSV view, you'll have to add them in the data source that you've elected to store the view, it's not possible to do it via the GUI.

I hope that helps!

Kind regards,

Chris

photo
1

Hi Chris,

How to identify the exact table name

/9761d9c5cbb057a40d082e224e1b40c0


Adding a new column in CSV is a common case I suppose, There should be an option to do that from GUI itself.

It is not possible by someone not having access to a database or don't know much about SQL.


Thanks & Regards

Pratap

photo
1

I have added 2 columns at the backend to datasource but these are not reflecting on the CSV level.only any update in existing columns are reflecting.

photo
1

Hi Pratap,

Apologies, I've looked into this some more and I believe you can append additional data via a CSV to the existing data. On our CSV import article on the Wiki, there is a section entitled Add Data which should explain the process.

Kind regards,

Chris

photo
1

Hi Chris,

That "Append" mentioned in the article is to append the rows not columns.

And I need to append additional columns from CSV.

Thanks & Regards

Pratap

photo