Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?