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.