Hi Dan, If you're guaranteed that the NumericID column will have an integer value, you can keep the column type as INT, and filter on 'WHERE NumericID IS NOT NULL'. This will filter out record1 in your example, which was your header row.
Matt Tucker From: Dan Y [mailto:[email protected]] Sent: Wednesday, March 07, 2012 11:29 AM To: [email protected] Subject: Re: Need a smart way to delete the first row of my data Hi guys - Thank you both. I was trying to avoid having to define two different schema for my data. For example, let's say the first three rows of my data were: record1: NumericID record2: 1234 record3: 5678 The schema I want associated with my data is: NumericID int But I think to implement the current suggestion I would have to first use an intermediate schema: NumericID string (This will allow all 3 records to validate against the schema, whereas record1 would have violated my desired schema). Then delete the Header row as Matt suggested. Lastly, associate the desired schema with the cleanded table: NumericID int Matt, you are probably already aware of this and that is why you called it a "least-worst" solution. But it is better than what I am doing now, so I think I will use it. Thanks again!
