Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Parameter to skip header rows in csv and file datasource #97

Closed
dgedgedge opened this issue Jan 11, 2021 · 8 comments
Closed

Parameter to skip header rows in csv and file datasource #97

dgedgedge opened this issue Jan 11, 2021 · 8 comments
Assignees
Labels
Milestone

Comments

@dgedgedge
Copy link

Hi,
First thanks for the tool.

I was trying to get some gouv info for the corona.
I get this one :

but I was not able to directly use it, because of initial dala rows.
It would be great to be able to specify the start row of the file as well as the colum titles / Date format...

Thanks in advance.

@Rello Rello self-assigned this Jan 28, 2021
@Rello
Copy link
Owner

Rello commented Jan 28, 2021

Hello,
thank you for the request.
This is about skipping header rows. I will look into this

@Rello
Copy link
Owner

Rello commented Jan 28, 2021

Hello @dgedgedge
I tested an implementation of a skip-header functionality.
this would be the result of your data. is this what you would expect?

Bildschirmfoto 2021-01-28 um 16 07 37

@Rello Rello changed the title Filter/Select columns in imported CSV Parameter to skip header rows in csv/json datasource Jan 28, 2021
@Rello Rello added this to the 3.3.0 milestone Jan 28, 2021
@dgedgedge
Copy link
Author

dgedgedge commented Jan 28, 2021

Yes, this seems great.
I am not yet an expert in using analytics, but this seems appropriate, and lead to usage of those data.
This answers to the request.

One question we may have for more features are :

  • Will we be able to select the colums to be printed afterward ?
  • What about the date format ?
  • Could the date be the 2nd column ?

But I think this should be another subject.
Thanks again for your concern.

@Rello
Copy link
Owner

Rello commented Jan 28, 2021

Hello,
what you are asking for is real so called ETL processing.
selecting dedicated columns and so on.
Its planned but I have to see how I can get this implemented in a usable way

@dgedgedge
Copy link
Author

OK.
Thanks for all.

@Rello
Copy link
Owner

Rello commented Jan 28, 2021

Approach to make the row selection flexible
Bildschirmfoto 2021-01-28 um 19 33 15

@Rello
Copy link
Owner

Rello commented Jan 28, 2021

Testing with a selector for the columns.
Would this work for you?

Bildschirmfoto 2021-01-28 um 23 05 34

@dgedgedge
Copy link
Author

That's perfect

@Rello Rello added testing development finished; in testing enhancement Feature request labels Jan 29, 2021
@Rello Rello changed the title Parameter to skip header rows in csv/json datasource Parameter to skip header rows in csv datasource Jan 30, 2021
@Rello Rello added pending release part of the next release version and removed testing development finished; in testing labels Jan 30, 2021
@Rello Rello changed the title Parameter to skip header rows in csv datasource Parameter to skip header rows in csv and file datasource Jan 30, 2021
@Rello Rello removed the pending release part of the next release version label Feb 13, 2021
@Rello Rello closed this as completed Feb 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants