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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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