0

CSV column definition in 1st line?

Hi-
Several CSV feeds have the schema defined as the first row. Is there a way to automatically assign the columns to these values? Something conceptually like
select * from csv where url="http://example.com/file.csv" and columns in (select * from csv where url="http://example.com/file.csv" | limit 1)
thanks!
miles

by
1 Reply
  • QUOTE (Miles Libbey @ Mar 19 2009, 05:45 PM) <{POST_SNAPBACK}>
    Hi-
    Several CSV feeds have the schema defined as the first row. Is there a way to automatically assign the columns to these values? Something conceptually like
    select * from csv where url="http://example.com/file.csv" and columns in (select * from csv where url="http://example.com/file.csv" | limit 1)
    thanks!
    miles


    That's a great idea but not something we have currently in production. There are a couple of issues with the csv handling that we are also looking to address.

    Jonathan
    0

Recent Posts

in YQL