Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
matKa
Contributor III
Contributor III

Get CSV from REST API connector and download data starting from second row.

My csv file loaded using REST API has two header rows at the top, I want to skip first row and download straight from second. I've tried to use "header is 1 lines" attribute in the connection but I get error that it expect closing bracke ")".

TableName:
SQL SELECT
Column1,

Column2

FROM CSV (header on, delimiter ",", quote """", header is 1 lines) "CSV_source"

When I remove "header is 1 lines" it loads csv normally but I need it to get headers from the second row, what am I doing wrong?

Labels (4)
2 Replies
danrdz
Contributor II
Contributor II

Hello!

Did you find any solution?

I am immersed in the same conflict.

Greetings!

matKa
Contributor III
Contributor III
Author

I wrote code extracting CSV on the server and in this code I remove first line. So not really a Qlik solution.