topic Re: Multiple Qvd's in QlikView

Multiple Qvd's

Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 26 Apr 2016 16:00:35 GMT

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

Tue, 26 Apr 2016 16:02:14 GMT

Hi,

please share with example

trdandamudi — Tue, 26 Apr 2016 17:32:48 GMT

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.

Tue, 26 Apr 2016 18:09:27 GMT

Hi,

attachment missed .

trdandamudi — Tue, 26 Apr 2016 18:43:34 GMT

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