Issue in importing CSV file in Qlikview application

[#1]

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

[suniljain]

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

[flipside]

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

[#4]

I got it. Thanks flipside:)

Xue Bin