Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ishpat2016
Contributor III
Contributor III

Excel extraction Column issue

Hi All,

I have multiple Excel files that needs to be loaded into QlikView at once. Attached is the sample.

Issue is "F" Column: this column is a link to HTML File which is placed in Excel's 6th column. When I load these files into QV either multiple files at once or a single File, I'm not able to get this last column "HTML REPORT" in QV.

I formatted this F column as A,B,C,D,E and then tried, QV reads it in a go but I cannot format each and every Excel file to happen.

Please help how to load this last column as well in the same given format as in Excel.

3 Replies
ishpat2016
Contributor III
Contributor III
Author

CapturePOC.PNG

wdchristensen
Specialist
Specialist

Since you can get the application to load once you have formatted it, one option would be to write a VBA macro in Excel to format all files in a given directory with your revised format.

https://www.thespreadsheetguru.com/the-code-vault/2014/4/23/loop-through-all-excel-files-in-a-given-...

Another option might be to save the files as CSV or TXT (tab delimited). This can be automated with VBA as well.

balar025
Creator III
Creator III

Hello Ishita,

Can you please show me the screenshot of error which you are getting?

Because when i have checked your qvw, you are loading only 5 column. And when i load excel file in my qvw, it is giving me all column which are present in sample excel file.

Can you please more elaborate on error?

Thanks

Ravi