cancel
Showing results for 
Search instead for 
Did you mean: 

Removing 1st and 2nd Row on CSV

galos11
7 - Data Storage
7 - Data Storage

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?

1 ACCEPTED SOLUTION

Helena_qbeeq
9 - Travel Pro
9 - Travel Pro

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:

Helena_qbeeq_0-1682670836559.png

Please let me know if this works for you : )

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

 

View solution in original post

1 REPLY 1

Helena_qbeeq
9 - Travel Pro
9 - Travel Pro

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:

Helena_qbeeq_0-1682670836559.png

Please let me know if this works for you : )

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