Is there an easy way to remove the header line skip on a schema other then rebuilding the schema from scratch? Here's the deal:
- Nightly, we receive .csv export to an SFTP server. This export contains data from multiple tables so we needed to extract data out per table and build a schema for each one.
- I used the schema wizard (I'm beginning to think I shouldn't), and thus, headers were contained in the data to make the schema.
- Nightly exports however, do not contain this header data. So Birst breaks cuz it thinks row 1 is a header row of the object and it's not.
Basically what I want to do is make the schema with the wizard, then go back and turn the skip header line option off. Is there an easy way to do this or do I need to rebuild the schemas from scratch?
Thanks!!