Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

unable to read file exported from Cobol

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

I can walk on water when it freezes
1 Solution

Accepted Solutions
ali_hijazi
Partner - Master II
Partner - Master II
Author

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

I can walk on water when it freezes

View solution in original post

1 Reply
ali_hijazi
Partner - Master II
Partner - Master II
Author

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

I can walk on water when it freezes