Multiple Qvd's

[#1]

Hi Experts,

i have one folder like (folder name)  "SOURCE"    in this folder having 5 Excel sheets like

Data 2016_4_25.xlsx

Data 2016_4_24.xlsx

Data 2016_4_23.xlsx

Data 2016_4_22.xlsx

Data 2016_4_21.xlsx

i will load all files at a time  by using     *

here my requirement is   how can i create   5 qvd's.(separate qvd for each sheet) .

[trdandamudi]

Use filebasename( ) Function to capture each file name and based on that create separate qvd's.

[#3]

Hi,

please share with example

[trdandamudi]

Please see the attached example file....

I created two sample excel files

1) File_1.xlsx

2) File_2,xlsx

Using the script I loaded both the excel files into Qlikview and then generated separate QVD for each excel file.

[#5]

Hi,

attachment missed .

[trdandamudi · Accepted solution]

I can see the attachments in community... Please refresh your browser... Any have I am attaching once again here...