galos11
04-27-2023Data Storage
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