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!

Reply via email to