Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello!
Did you find any solution?
I am immersed in the same conflict.
Greetings!
I wrote code extracting CSV on the server and in this code I remove first line. So not really a Qlik solution.