Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear
I have a file exported from Cobol (delimited by ';')
QlikView is unable to read it because this file always contains an empty line then the column names start at line 2
However if I open it in excel I have the option select from which line to start reading; so I choose line 2 then QlikView is able to read the generated excel file
How can I force QlikView to start reading from line 2?
I don't want to open the file from excel then .....
Please advise
Oh I just found the solution!!!!
in the TableFiles pop-up choose under the Header Size the option Lines and then select 1 in the input to the right
this is similar to the option in excel to start reading from a specific line
Oh I just found the solution!!!!
in the TableFiles pop-up choose under the Header Size the option Lines and then select 1 in the input to the right
this is similar to the option in excel to start reading from a specific line