Forum Discussion

galos11's avatar
galos11
Data Storage
04-27-2023
Solved

Removing 1st and 2nd Row on CSV

Have a csv file that is being created out of a platform that adds a date created on the first row, blank 2nd, then the header, and data.

Is there a way to remove the first 2 rows easily?

  • Hi galos11 ,

    If you are trying to use that csv file in a data model, you have an option to skip the first rows, so you can read your data correctly.

    After chosing csv as a data source and referencing the csv file, you come to this screen and you can adjust the ignore first rows parameter to your needs:

    Please let me know if this works for you : )

    Always here to help,
    Helena from QBeeQ
    [email protected]
    QBeeQ - Gold Implementation and Development Partner

     

1 Reply

Replies have been turned off for this discussion
  • Hi galos11 ,

    If you are trying to use that csv file in a data model, you have an option to skip the first rows, so you can read your data correctly.

    After chosing csv as a data source and referencing the csv file, you come to this screen and you can adjust the ignore first rows parameter to your needs:

    Please let me know if this works for you : )

    Always here to help,
    Helena from QBeeQ
    [email protected]
    QBeeQ - Gold Implementation and Development Partner