You could just try to have the headers in a single line too... emulating the structure that the rest of the data follows.
-----Original Message----- From: Kunal Khatua [mailto:[email protected]] Sent: Tuesday, August 01, 2017 9:38 PM To: [email protected] Subject: RE: delimiter in column values So, the way you’ve shown your data is basically in this format: <List of column headers, one per line> <actual column data, one row per line> Unfortunately, I don't believe the text reader in Drill is that advanced as to interpret the list of column headers across multiple lines, while the actual data is in a single line per row. Typically text data is in CSV (or other delimiters similar to the comma) and can have the first line representing a header. Also, I'm not sure if there was ever an option introduced to allow skipping of the initial set of lines within a text file being read. -----Original Message----- From: Divya Gehlot [mailto:[email protected]] Sent: Tuesday, August 01, 2017 7:06 PM To: [email protected] Subject: Re: delimiter in column values For my sample dataset as you advised I surrounded with single columns also with quotes and the results are as below : col_Column1 Column2 Column3 Column4 Column5 "Chifley" "coltwodata5" "" "" "" "colonedata1" "coltwodata1" "-35.924476" "138.5987123" "" "colonedata2" "coltwodata2" "-27.4372536" "153.0304583" "137" "colonedata4" "coltwodata4" "-33.8724176" "151.2067579" "" "colonedata5" "coltwodata5" "" "" "" "This col6 data" "coltwodata6" "-33.869732" "151.2055553" "This col7 data yes." "coltwodata7" "1.2845045" "103.8482739" colonedata3" "coltwodata3" "-35.2793885" "149.1233503" "134" Thanks, Divya On 1 August 2017 at 22:39, Kunal Khatua <[email protected]> wrote: > I think you need quotes around the single word datasets as well, > because the quotes act as String delimiters and help in indicating the > start and end of a String. > > Is there a reason why the single word strings cannot be in quotes as well? > > -----Original Message----- > From: Divya Gehlot [mailto:[email protected]] > Sent: Tuesday, August 01, 2017 3:04 AM > To: [email protected] > Subject: delimiter in column values > > Hi, > I have data set which has delimeter in first column value when I read > the data set It provides the output below : > > col_Column1 > Column2 > Column3 > Column4 > Column5 > > "This col6 data" coltwodata6 -33.869732 151.2055553 "This col7 data yes." > coltwodata7 1.2845045 103.8482739 Chifley coltwodata5 > colonedata1 coltwodata1 -35.924476 138.5987123 > colonedata2 coltwodata2 -27.4372536 153.0304583 137 > colonedata3 coltwodata3 -35.2793885 149.1233503 134 > colonedata4 coltwodata4 -33.8724176 151.2067579 > colonedata5 coltwodata5 > > > > How can I read the column1 values as is without getting split into two > columns for instance the Column values should be > Column1 > colonedata1, > colonedata2, > colonedata3, > colonedata4, > colonedata5, > "This, col6 data" > "This, col7 data" > Chifley, > > Appreciate the help ! > > Thanks , > Divya >
