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: 
Not applicable

Issue in importing CSV file in Qlikview application

Hi,

       Pleasefind attached one CSV file format.

    Can any one help me to load this CSV file in Qlikview application.

Issue is QV appilcation not loading the CSV file due to some column dont have header name(field name) but it has data.

Thanks,

Antony

12 Replies
suniljain
Master
Master

you can eliminare RowNo() field if you donot required. its for physical indexing of records.

flipside
Partner - Specialist II
Partner - Specialist II

I've used the RowNo() function to mark the top row of data so it can be removed later on (there are various ways to do this, but I have used the 'right keep ... where Hdr <> 1').  Bear in mind you are loading the original headers as text, then inspecting them one by one and renaming based on whether the value is there or empty. 

flipside

Not applicable
Author

I got it. Thanks flipside:)

Xue Bin