Azure SQL Database
An Azure relational database service.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
when i run the usual command below, all my row headers are in one column in the output.
how do i fix that. Normally i would use 'sep=;' on pyspark. can someone explain how i do that on sql
SELECT TOP 100 * FROM OPENROWSET( BULK 'https://path...', FORMAT = 'CSV', HEADER_ROW = TRUE, PARSER_VERSION = '2.0' ) AS [result]
Hi @FERGUS ESSO KETCHA ASSAM Welcome to the Microsoft Q&A forum, Thanks for posting your question.
Can you try the field terminator mentioned below, you can also refer to the example provided here.
SELECT TOP 100 * FROM OPENROWSET( BULK 'https://path...', FORMAT = 'CSV', HEADER_ROW = TRUE, PARSER_VERSION = '2.0', FIELDTERMINATOR = '\t' ) AS [result]