New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.

Who Me Too'd this topic

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)
Who Me Too'd this topic